mysql没有关键字提示功能,使我在今天开发项目时候,遇到这样的问题
Caused by: com.mysql.jdbc.exceptions.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 'check, password, account) values ('helloworld', 'changsha', '5710456', 'lisi', '' at line 1
我一头雾水,我用hibernate操作数据库没有写sql语句,怎么出现sql语句错误了,我搞了很久没有搞出来,我仔细看了错误信息,我估计check,password,account中一个字段有错误,于是三个字段一个一个改名来测试,我终于找到问题,check有问题,我看mysql的手册,它原来是mysql的关键字,所以用mysql建表时,一定注意这个问题
Caused by: com.mysql.jdbc.exceptions.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 'check, password, account) values ('helloworld', 'changsha', '5710456', 'lisi', '' at line 1
我一头雾水,我用hibernate操作数据库没有写sql语句,怎么出现sql语句错误了,我搞了很久没有搞出来,我仔细看了错误信息,我估计check,password,account中一个字段有错误,于是三个字段一个一个改名来测试,我终于找到问题,check有问题,我看mysql的手册,它原来是mysql的关键字,所以用mysql建表时,一定注意这个问题