错误信息:
### 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
错误原因:
更新的时候,更新语句之间缺少逗号(格式错误)。