com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; che
来源:互联网 发布:声音剪辑合成软件 编辑:程序博客网 时间:2024/05/16 08:22
错误信息:
### 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 MySQL server version for the right syntax to use near 'autopublish = '0'
publish_Date = nullwhere pk_column_ex = 429' at line 10
### The error may involve com.cn.column.mapper.ColumnDevelopMapper.updateByPrimaryKey-Inline
### The error occurred while setting parameters
### SQL: update zhly_column_extend set home_template = ?, list_template = ?, detail_template = ?, max_display = ?, seo_keyword = ?, seo_describe = ?, generate_static_file = ? autopublish = ? publish_Date = ? where pk_column_ex = ?
### 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 'autopublish = '0'
publish_Date = null
where pk_column_ex = 429' at line 10
; 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 'autopublish = '0'
publish_Date = null
where pk_column_ex = 429' at line 10
错误原因:
更新的时候,更新语句之间缺少逗号(格式错误)。
阅读全文
0 0
- com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; che
- com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; che
- com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; che
- com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax.....
- com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax;解决办法
- com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax解决办法
- 解决com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax;错误
- com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax;
- com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax
- Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL
- Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL
- mybatis报“com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL s”
- com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You have an error in your SQL syntax;
- com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in
- MySql JDBC:You have an error in your SQL syntax;
- Spring JPA-Hibernate报错:com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an er解决方案
- com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'password' in
- You have an error in your SQL syntax
- 高性能序列化protostuff
- 多线程编程 使线程具有有序性
- Linux文件查找命令
- 使用spring aop管理事务
- linux+jenkins+gradle+gitlab自动化打包发布andriod APP
- com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; che
- MySQL入门---登陆、退出、修改提示符、常用规范
- ajax中的timeout
- java Thread interrupt方法
- WAF绕过参考资料
- <NOIP> 6 . P1089 津津的储蓄计划
- 页面显示时间为object Object
- matplotlib2.02基本画图
- AFNetworking 的详细使用