今天使用SpringBoot整合SSM框架完成用户注册功能,过程中在执行SQL语句时发生错误。
错误信息如下:
### 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 'in to user(user_name,user_pwd) values('ffff','123')' at line 1
### The error may exist in com/cao/springbootpainting/dao/UserMapper.java (best guess)
### The error may involve com.cao.springbootpainting.dao.UserMapper.save-Inline
### The error occurred while setting parameters
### SQL: insert in to user(user_name,user_pwd) 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 'in to user(user_name,user_pwd) values('ffff','123')' at line 1
; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorExce