记录今天建表order,然后项目运行时mapper.xml报错
### The error occurred while setting parameters
找了好几个小时,以为是某个参数名是关键字,结果最后发现order是sql关键字!!!!!!!!!不可以直接写order,需要在sql语句中给order加上``就可以解决
比如:
insert into order (cid, ecode, ename,
ephone, eaddress, eid,
oid, ostatus, mstatus,
omoney)
变为
insert into `order` (cid, ecode, ename,
ephone, eaddress, eid,
oid, ostatus, mstatus,
omoney)