Today with SPRINGMVC to do the modification add operation, the previous operation has implemented the addition of modifications, but always reported Com.mysql.jdbc.exceptions.MySQLSyntaxErrorException:You has an error in your SQL syntax ...
Find a lot of information on the Internet, that is the database coding problem, SPRINGMVC set Characterencodingfilter filter, these solutions can not solve my problem
No, I pasted the SQL statement from hibernate into the navicat for SQL operations, and the same error was reported.
Accidentally found that I this table of the Limit field color is blue, suddenly, the original is with the database keyword, modify the limit field, the result is normal operation
So we should be careful to avoid and database keyword duplication, resulting in unnecessary problems!
mysql keyword list: http://www.cnblogs.com/jiangshan5xian/archive/2013/03/16/2963496.html
SpringMVC:com.mysql.jdbc.exceptions.MySQLSyntaxErrorException:You has an error in your SQL syntax;