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

时间:2020-02-18 20:26:28   收藏:0   阅读:1284

今天在用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后恢复正常

原文:https://www.cnblogs.com/master-road/p/12327458.html

评论(0
© 2014 bubuko.com 版权所有 - 联系我们:wmxa8@hotmail.com
打开技术之扣,分享程序人生!