1064，“您的SQL语法有错误

Question

错误如下：

gutschy@kiste:~/pizza/pizza_daten$ python datenimport3.py
Traceback (most recent call last):
  File "datenimport3.py", line 20, in <module>
    ")
  File "/usr/lib/python2.7/dist-packages/MySQLdb/cursors.py", line 174, in execute
    self.errorhandler(self, exc, value)
  File "/usr/lib/python2.7/dist-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler
    raise errorclass, errorvalue
_mysql_exceptions.ProgrammingError: (1064, "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 ''Adressliste_forum1_v4.csv'            INTO TABLE pizzeria_table             FIE' at line 1")
gutschy@kiste:~/pizza/pizza_daten$

这里是datenimport3.py

^{pr2}$

四个月前它工作得很好，比我杀死debian 7还好，现在我要像以前一样把它带来。我添加了最后一个字段“banner”新的，但我没有做更多。在

Answer 1

您可以通过查找以下内容来整理所有的回溯信息：

...for the right syntax to use near ''Adressliste_forum1_v4.csv'  INTO ...

对于一个1064错误，MySQL在“use near”之后显示语句，从发现它的解析错误的位置开始。在

现在，你的陈述不应该从

^{pr2}$

是吗？在