我想創(chuàng)建一個存儲在文件中的數據的數據庫。為此,我使用文件處理從存儲的文件中讀取數據并輸入到我的數據庫表中。但它顯示下面給出的錯誤。這是將數據存儲選項從文件切換到數據庫的正確方法嗎?發(fā)生的錯誤如下 - :Traceback (most recent call last): File "C:/Users/sarth/AppData/Roaming/JetBrains/PyCharmCE2020.1/scratches/scratch_2.py", line 61, in <module> indatabase() File "C:/Users/sarth/AppData/Roaming/JetBrains/PyCharmCE2020.1/scratches/scratch_2.py", line 54, in indatabase cur.execute ("SELECT * FROM PETROL") File "C:\Users\sarth\AppData\Local\Programs\Python\Python38-32\lib\site-packages\mysql\connector\cursor.py", line 566, in execute self._handle_result(self._connection.cmd_query(stmt)) File "C:\Users\sarth\AppData\Local\Programs\Python\Python38-32\lib\site-packages\mysql\connector\connection.py", line 537, in cmd_query result = self._handle_result(self._send_cmd(ServerCmd.QUERY, query)) File "C:\Users\sarth\AppData\Local\Programs\Python\Python38-32\lib\site-packages\mysql\connector\connection.py", line 436, in _handle_result raise errors.get_exception(packet)mysql.connector.errors.ProgrammingError: 1146 (42S02): Table 'pump.petrol' doesn't existFailed to create table in MySQL: 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AMOUNT FLOAT ,QUANTITY FLOAT ,Year VARCHAR(10) ,Date DATE' at line 1這是從文件中讀取數據然后輸入數據庫的代碼。
添加回答
舉報
0/150
提交
取消