我在创建商品添加到数据库时,使用insertSelective()方法,也设置主键自增了,为何会报下面的错误,xml文件是代码生成器生成的,useGeneratedKeys和keyProperty我也写了-慕课网

我在创建商品添加到数据库时,使用insertSelective()方法,也设置主键自增了,为何会报下面的错误,xml文件是代码生成器生成的,useGeneratedKeys和keyProperty我也写了

来源：4-3 商品模型模型--商品创建03

慕村6028198

2019-09-24 12:52

### The error may involve com.miaosha.dao.ItemMapper.insertSelective-Inline### The error occurred while setting parameters### SQL: > insert into item ( title, price, description, img_url ) values ( ?, ?, ?, ? )

### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '>

insert into item ( title, price, ' at line 1;

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 MariaDB server version for the right syntax to use near '>

insert into item ( title, price, ' at line 1]

写回答关注