                        課程
                    
                        /后端開發(fā)
                        
                            /Java
                        
                        /MyBatis-Plus入門

使用Mp的條件構(gòu)造器查詢時(shí)時(shí)遇到mysql關(guān)鍵字怎么辦呀

?type 和?condition 是mysql關(guān)鍵字?

慕九州9160395

2020-01-19

源自：MyBatis-Plus入門

關(guān)注問(wèn)題我要回答

1095

操作

收起

2 回答

老猿
2020-01-19

不太明白，你是數(shù)據(jù)庫(kù)的表字段使用了關(guān)鍵字嗎？如果是的話，前后加單引號(hào)轉(zhuǎn)義即可吧。方便的話，把那張表和sql語(yǔ)句發(fā)出來(lái)，我看看怎么弄。

0 回復(fù) 有任何疑惑可以回復(fù)我~

收起回答

慕九州9160395 提問(wèn)者
2020-01-19

@TableField("`condition`")
@ApiModelProperty(name?=?"condition"?,?value?=?"經(jīng)驗(yàn)要求")
private?String?condition;

@TableField("`type`")
@ApiModelProperty(name?=?"type"?,?value?=?"任職方式")
private?String?type;

老師我用@TablleField注解解決了??

condition??type?是mysql的關(guān)鍵字

這是我用條件構(gòu)造器生成的錯(cuò)誤信息和sql?

Error querying database.? 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 'condition,education,type,address,eid,createtime,state,url,label,content1,content' at line 1

### SQL: SELECT? id,jobname,salary,condition,education,type,address,eid,createtime,state,url,label,content1,content2? FROM tb_recruit??