mysql版本8.0，PC管理后臺(tái)登錄正常，點(diǎn)擊商品模塊報(bào)錯(cuò)，詳細(xì)信息如下：

Cause: java.sql.SQLSyntaxErrorException: 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 ',spec_type,is_recycle,is_sub,is_show,audit_status,is_audit,reason,is_del,create_' at line 1 ### The error may exist in com/zbkj/service/dao/ProductDao.java (best guess) ### The error may involve defaultParameterMap ### The error occurred while setting parameters ### SQL: SELECT id,mer_id,image,flat_pattern,slider_image,name,intro,keyword,cate_id,brand_id,category_id,guarantee_ids,price,vip_price,ot_price,unit_name,sales,stock,cost,ficti,browse,code_path,soure_link,video_link,temp_id,sort,rank,spec_type,is_recycle,is_sub,is_show,audit_status,is_audit,reason,is_del,create_time,update_time,type,is_paid_member,is_auto_up FROM eb_product WHERE (mer_id = ? AND is_show = ? AND is_recycle = ? AND is_del = ? AND audit_status IN (?,?)) ORDER BY sort DESC,id DESC LIMIT ? ### Cause: java.sql.SQLSyntaxErrorException: 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 ',spec_type,is_recycle,is_sub,is_show,audit_status,is_audit,reason,is_del,create_' at line 1 ; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: 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 ',spec_type,is_recycle,is_sub,is_show,audit_status,is_audit,reason,is_del,create_' at line 1

初步發(fā)現(xiàn)是字段rank是關(guān)鍵詞