Sql中关键字问题

港控/mmm° 2023-07-03 06:09 3阅读 0赞

\#\#\# SQL: INSERT INTO tb\_spec\_param  ( id,cid,group\_id,name,numeric,unit,generic,searching,segments ) 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 'numeric,unit,generic,searching,segments ) VALUES( null,76,1,'test',0,null,1,0,''' 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 'numeric,unit,generic,searching,segments ) VALUES( null,76,1,'test',0,null,1,0,''' at line 1\] with root 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 'numeric,unit,generic,searching,segments ) VALUES( null,76,1,'test',0,null,1,0,''' at line 1  
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~\[na:1.8.0\_211\]  
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) ~\[na:1.8.0\_211\]  
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~\[na:1.8.0\_211\]  
    at java.lang.reflect.Constructor.newInstance(Constructor.java:423) ~\[na:1.8.0\_211\]  
研究好一会，发现![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzMyNTY1MjY3_size_16_color_FFFFFF_t_70][]

是实体中的单引号的问题， 应该是倒引号才对， 不然sql是不识别的，如图：

![20200203093017862.png][]

在此提出，以免以后会遇到

@Column(name = "`numeric`")

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzMyNTY1MjY3_size_16_color_FFFFFF_t_70]: https://img-blog.csdnimg.cn/20200203092856901.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzMyNTY1MjY3,size_16,color_FFFFFF,t_70
[20200203093017862.png]: https://img-blog.csdnimg.cn/20200203093017862.png