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

数据库   发布日期:2025年05月25日   浏览次数:181

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

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

以上就是Python操作mysql数据库出现pymysql.err.ProgrammingError: (1064, "You have an error in your SQL syntax; check的详细内容,更多关于Python操作mysql数据库出现pymysql.err.ProgrammingError: (1064, "You have an error in your SQL syntax; check的资料请关注九品源码其它相关文章!