ave an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IS

### 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 'IS
        )
        values
          
            (
            null
          ' at line 27
### The error may exist in file [D:LenovoGitLms_ordercenterpcsd-ordercenter-ordermanagement-order argetclassesmybatismapperworkingCustomerCharacteristicRelationshipDao_extend.xml]
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: insert into customer_characteristic_relationship         (         update_by         ,is_delete         ,create_by         ,remark         ,category_id            ,IS         )         values                        (             ?             ,?             ,?             ,?             ,?             ,?             ,?             ,?             ,?             ,?              ,?             )
### 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 'IS
        )
        values
          
            (
            null
          ' at line 27
; bad SQL grammar []
 
 
 
 
 
is 是关键字.字参数 改成  `is`
原文地址:https://www.cnblogs.com/suizhikuo/p/14469544.html