为了账号安全,请及时绑定邮箱和手机立即绑定

插入数据报错

This application has no explicit mapping for /error, so you are seeing this as a fallback.

Tue Sep 04 08:56:32 CST 2018

There was an unexpected error (type=Internal Server Error, status=500).

### Error updating database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'desc,add_time ) VALUES( null,'2222','null','2018-09-04 08:56:32' )' at line 1 ### The error may involve com.agilephotonics.mappers.examination.ExaminationExamcategoryMapper.insert-Inline ### The error occurred while setting parameters ### SQL: INSERT INTO examination_examcategory ( id,name,desc,add_time ) VALUES( ?,?,?,? ) ### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'desc,add_time ) VALUES( null,'2222','null','2018-09-04 08:56:32' )' 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 MariaDB server version for the right syntax to use near 'desc,add_time ) VALUES( null,'2222','null','2018-09-04 08:56:32' )' at line 1


正在回答

2 回答

看看你的字段类型是否匹配数据库的字段类型

0 回复 有任何疑惑可以回复我~

SQL语法错误?

0 回复 有任何疑惑可以回复我~

举报

0/150
提交
取消

插入数据报错

我要回答 关注问题
意见反馈 帮助中心 APP下载
官方微信