com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; che

错误信息:

### 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
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值