当前使用版本(必填,否则不予处理)
3.2.0
该问题是如何引起的?(确定最新版也有问题再提!!!)
数据表结构时最后一列是desc
重现步骤(如果有就写完整)
报错信息
SELECT id,UPDATED_TIME,UPDATED_BY,isParent,code,is_delete,type,ext_info,CREATED_BY,parentCode,grade,name,CREATED_TIME,desc FROM wuxi_dictionaries WHERE (is_delete = 0 AND parentCode = 0)
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 'desc FROM wuxi_dictionaries WHERE (is_delete = 0 AND parentCode = 0)' at line 1
Comment From: nishimoguima
desc是关键字,MySQL需要用``号将desc包括其中