MyBatis

mybatis 提示sql语法错误 看来看去sql没问题,,日了狗了 表的名字是关键字 order,,改成user_order 就可以了,希望能帮到后来人。

### Error updating 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 'order (starterDate,happyDate,longitude,latitude,userid) VALUES ('2022/03/24','20' at line 1
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: INSERT INTO order (starterDate,happyDate,longitude,latitude,userid) VALUES (?,?,?,?,?)
### 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 'order (starterDate,happyDate,longitude,latitude,userid) VALUES ('2022/03/24','20' 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 'order (starterDate,happyDate,longitude,latitude,userid) VALUES ('2022/03/24','20' at line 1] with root cause

posted @ 2022-03-24 21:58  白芷100  阅读(25)  评论(0)    收藏  举报