Python操作mysql数据库出现pymysql.err.ProgrammingError: (1064, “You have an error in your SQL syntax; check

gtxyzz 安全防护 2023-02-27 703浏览 0

今天在用Python操作mysql数据库出现pymysql.err.ProgrammingError: (1064, “You have an error in your SQL syntax; check报错

"SELECT Failure_code,describe from failure_occur_now order by ID DESC LIMIT 1“
黄色区域为报错的位置
仔细查找，发现没有语法错误啊，后面将,describe删掉不报错了，原来describe应该是MysqL的保留字，后来讲describe字段改名为Failure_describe后恢复正常