mybatis-plus insert时报错表名order

原创已于 2022-03-08 11:21:22 修改 · 1.3k 阅读

1 ·

CC 4.0 BY-SA版权

文章标签：

#java #mysql #sql

于 2022-03-08 11:17:56 首次发布

mybatis-plus 专栏收录该内容

3 篇文章

订阅专栏

博客作者在尝试插入数据到数据库时遇到了一个问题，插入操作虽然没有语法错误，但无法成功执行。经过排查，发现问题是由于使用了MySQL的关键字'order'作为表名，导致SQL语句执行时出现语法错误。解决方案是将表名改为'pro_order'，从而避开了关键字冲突，问题得到解决。这个案例提醒我们在数据库设计时需要注意避免使用保留字作为表名或字段名。

今天遇到一个问题就是insert的时候语法没问题插入日志也没问题但是就是插不进去(忙了一上午啊我的时间啊可恶)

报错如图:

SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@3180131e] was not registered for synchronization because synchronization is not active
JDBC Connection [HikariProxyConnection@1409112532 wrapping com.mysql.cj.jdbc.ConnectionImpl@43c3354] will not be managed by Spring
==>  Preparing: INSERT INTO order ( pk_id, order_price, product_id ) VALUES ( ?, ?, ? )
==> Parameters: 1(String), 50(Integer), 1501002853813071874(String)
Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@3180131e]

org.springframework.jdbc.BadSqlGrammarException: 
### 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  ( pk_id,
order_price,
product_id )  VALUES  ( '1',
50,
'15010028538130718' at line 1
### The error may exist in com/zhang/mapper/OrderMapper.java (best guess)
### The error may involve com.zhang.mapper.OrderMapper.insert-Inline
### The error occurred while setting parameters
### SQL: INSERT INTO order  ( pk_id, order_price, product_id )  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  ( pk_id,
order_price,
product_id )  VALUES  ( '1',
50,
'15010028538130718' 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  ( pk_id,
order_price,
product_id )  VALUES  ( '1',
50,
'15010028538130718' at line 1

然后关注点放在

Cause: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to

左想想右想想

我把表名改了 order->pro_order他就没问题了可恶啊(order为mysql的关键字拼接sql语句会出现问题)

mybatis-plus insert时报错 表名order

mybatis-plus insert时报错表名order