PYMYSQL错误pymysql.err.ProgrammingError：(1064，“您的SQL语法中有错误")

Question

这是完整的错误

Traceback (most recent call last):
  File "Desktop/Work/RDS_LAMDA_Stuff/RDS_Node_Stuff/test.py", line 26, in <module>
    handler()
  File "Desktop/Work/RDS_LAMDA_Stuff/RDS_Node_Stuff/test.py", line 17, in handler
    cursor.execute('SELECT * FROM Reads')
  File "Desktop/Work/RDS_LAMDA_Stuff/RDS_Node_Stuff/pymysql/cursors.py", line 148, in execute
    result = self._query(query)
  File "Desktop/Work/RDS_LAMDA_Stuff/RDS_Node_Stuff/pymysql/cursors.py", line 310, in _query
    conn.query(q)
  File "Desktop/Work/RDS_LAMDA_Stuff/RDS_Node_Stuff/pymysql/connections.py", line 548, in query
    self._affected_rows = self._read_query_result(unbuffered=unbuffered)
  File "Desktop/Work/RDS_LAMDA_Stuff/RDS_Node_Stuff/pymysql/connections.py", line 775, in _read_query_result
    result.read()
  File "Desktop/Work/RDS_LAMDA_Stuff/RDS_Node_Stuff/pymysql/connections.py", line 1156, in read
    first_packet = self.connection._read_packet()
  File "Desktop/Work/RDS_LAMDA_Stuff/RDS_Node_Stuff/pymysql/connections.py", line 725, in _read_packet
    packet.raise_for_error()
  File "Desktop/Work/RDS_LAMDA_Stuff/RDS_Node_Stuff/pymysql/protocol.py", line 221, in raise_for_error
    err.raise_mysql_exception(self._data)
  File "Desktop/Work/RDS_LAMDA_Stuff/RDS_Node_Stuff/pymysql/err.py", line 143, in raise_mysql_exception
    raise errorclass(errno, errval)
pymysql.err.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 'Reads' at line 1")

这里是我的代码

from multiprocessing import connection
import pymysql
from pymysql.cursors import Cursor

# RDS config
endpoint = '********'
username = '********'
password = '********'
database_name = '*********'

#connection config

connection = pymysql.connect(host=endpoint,user=username,passwd=password,db=database_name)

def handler():
    cursor = connection.cursor()
    cursor.execute('SELECT * FROM Reads')

    rows = cursor.fetchall()

    for row in rows:
        print("{0} {1} {2} {3}".format(row[0], row[1], row[2], row[3]))



handler()

我的数据库中还有另外两个表，当我查询它们时，它们工作得很好，但是这个表似乎是唯一一个导致错误的表。

如果这个太模糊的话，可以再多问一次。

Answer 1

在这种情况下，检查手册是值得的--读取是一个保留字，因此必须进行回拨--最好还是不要使用保留字，否则您将不得不永远记住在代码中回勾。