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 = null
    where 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