欢迎访问 生活随笔！
TAG聚合

生活随笔

当前位置： 首页 > 运维知识 > 数据库 >内容正文

数据库

pymysql.err.InternalError: (1054, Unknown column '27D24A3B' in 'where clause')之错误解决

发布时间：2025/3/15 数据库 32 豆豆
生活随笔 收集整理的这篇文章主要介绍了 pymysql.err.InternalError: (1054, Unknown column '27D24A3B' in 'where clause')之错误解决 小编觉得挺不错的,现在分享给大家,帮大家做个参考.

原代码：

query_image_path1='SELECT imageTempFilename_0,imageTempFilename_1 FROM %s'% tablename query_image_path2=' where IDprojectTemp=%s and IDproject=%s and cameraID=%s and imageflag=%s'%(IDprojectTemp,IDproject,cameraID,imageflag) query_image_path_sql=query_image_path1+query_image_path2 print(query_image_path_sql) cursor.execute(query_image_path_sql) value_list = cursor.fetchall()###################################### #query_image_path_sql:SELECT imageTempFilename_0,imageTempFilename_1 FROM engineeringdata20190124 where IDprojectTemp=27D24A3B-ECF3-40ff-BC79-9A0B8417A0CD and IDproject=C3A9B395-12A5-4821-AD00-B8C02E5C3904 and cameraID=1 and imageflag=0

运行出现错误：pymysql.err.InternalError: (1054, "Unknown column '27D24A3B' in 'where clause'")

将query_image_path2中的单引号改为双引号。%s上加双引号，则不报错。改正后如下：

query_image_path1='SELECT imageTempFilename_0,imageTempFilename_1 FROM %s'% tablename query_image_path2=" where IDprojectTemp='%s' and IDproject='%s' and cameraID='%s' and imageflag='%s'"%(IDprojectTemp,IDproject,cameraID,imageflag) query_image_path_sql=query_image_path1+query_image_path2 print(query_image_path_sql) cursor.execute(query_image_path_sql) value_list = cursor.fetchall() print('value_list:', value_list)

 

总结

以上是生活随笔为你收集整理的pymysql.err.InternalError: (1054, Unknown column '27D24A3B' in 'where clause')之错误解决的全部内容，希望文章能够帮你解决所遇到的问题。

如果觉得生活随笔网站内容还不错，欢迎将生活随笔推荐给好友。