### Error updating database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You

最新推荐文章于 2023-10-30 15:12:12 发布

安好安好33

最新推荐文章于 2023-10-30 15:12:12 发布

阅读量1.8k

点赞数 1

文章标签： mysql 数据库

本文链接：https://blog.csdn.net/weixin_44093711/article/details/116974238

版权

解决mybatis-plus插入的坑

### Error updating database.  Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 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 (userEmail,productId,orderId,createTime,money,integral) values ('325359288' at line 1
### The error may exist in com/dpj/mapper/ShopMapper.xml
### The error may involve com.dpj.mapper.ShopMapper.insertProductOrder-Inline
### The error occurred while setting parameters
### SQL: INSERT INTO order (userEmail,productId,orderId,createTime,money,integral) values (?,?,?,?,?,?)
### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 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 (userEmail,productId,orderId,createTime,money,integral) values ('325359288' at line 1
; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 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 (userEmail,productId,orderId,createTime,money,integral) values ('3253598' at line 1] with root cause

原因插入语句出现了与mp的关键字了，这里sql语句没错，错在order这个表的关键词
改成ordertemp这个表

<insert id="insertProductOrder" parameterType="Order">
    INSERT INTO ordertemp (userEmail,productId,orderId,createTime,money,integral) values (#{usrEmail},#{productId},#{orderId},#{createTime},#{money},#{integral})
</insert>