Çalışıyor...
Fakat ben SQL kodunu Python ile çalıştırmak istiyorum.
Bunun için izlediğim yol:
`import pymysql.cursors
mysql = pymysql.connect(
host='localhost',
user='root',
password='123456',
charset='utf8mb4',
cursorclass=pymysql.cursors.DictCursor)
imleç = mysql.cursor()
veri_tabanı = imleç.execute("""CREATE DATABASE KÜTÜPHANE""")
düzen = imleç.execute("""CREATE TABLE KÜTÜPHANE (ID varchar(45), KİTAP_ADI varchar(45), YAZAR varchar(45), YAYINEVİ varchar(45))""")`
<!--- ALDIĞIM HATA ---!>
Traceback (most recent call last):
File "c:\Users\arkhe\OneDrive\Masaüstü\programlama\KAYNAKLAR_masaüstü\deneme.py", line 27, in <module>
düzen = imleç.execute("""CREATE TABLE KÜTÜPHANE (ID varchar(45), KİTAP_ADI varchar(45), YAZAR varchar(45), YAYINEVİ varchar(45))""")
File "C:\Users\arkhe\AppData\Local\Programs\Python\Python310\lib\site-packages\pymysql\cursors.py", line 148, in execute
result = self._query(query)
File "C:\Users\arkhe\AppData\Local\Programs\Python\Python310\lib\site-packages\pymysql\cursors.py", line 310, in _query
conn.query(q)
File "C:\Users\arkhe\AppData\Local\Programs\Python\Python310\lib\site-packages\pymysql\connections.py", line 548, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File "C:\Users\arkhe\AppData\Local\Programs\Python\Python310\lib\site-packages\pymysql\connections.py", line 775, in _read_query_result
result.read()
File "C:\Users\arkhe\AppData\Local\Programs\Python\Python310\lib\site-packages\pymysql\connections.py", line 1156, in read
first_packet = self.connection._read_packet()
File "C:\Users\arkhe\AppData\Local\Programs\Python\Python310\lib\site-packages\pymysql\connections.py", line 725, in _read_packet
packet.raise_for_error()
File "C:\Users\arkhe\AppData\Local\Programs\Python\Python310\lib\site-packages\pymysql\protocol.py", line 221, in raise_for_error
err.raise_mysql_exception(self._data)
File "C:\Users\arkhe\AppData\Local\Programs\Python\Python310\lib\site-packages\pymysql\err.py", line 143, in raise_mysql_exception
raise errorclass(errno, errval)
pymysql.err.OperationalError: (1046, 'No database selected')
Bu hatayı nasıl düzeltirim?