使用Python在MYSQL数据库中建表报错

Question

我想创建一个存储在文件中的数据的数据库。为此，我使用文件处理从存储的文件中读取数据并输入到我的数据库表中。但它显示下面给出的错误。

这是将数据存储选项从文件切换到数据库的正确方法吗？

发生的错误如下 - ：

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 exist

Failed 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

这是从文件中读取数据然后输入数据库的代码。

Answer 1

在这条线上CREATE&nbsp;TABLE&nbsp;PETROL...你错过了之后的右括号Date DATE