The error may exist in com/xjh/mange/mapper/WebMapper.java (best guess)

The error may involve com.xjh.mange.mapper.WebMapper.insert-Inline

The error occurred while setting parameters

SQL: INSERT INTO web ( user_name, web_name, web_url, des, web_icon, delete, create_time ) VALUES ( ?, ?, ?, ?, ?, ?, ? )

Cause: java.sql.SQLSyntaxErrorException: 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 'delete,

create_time ) VALUES ( 、

**

字段不能是mysql关键字,我怪不得一直添加不了数据,头疼

**

我把插入语句翻到sqlyog才发现,下次要注意了。

**
**
sqlyog会把关键字会转换为大写蓝色,一眼就能看到

Logo

为开发者提供学习成长、分享交流、生态实践、资源工具等服务,帮助开发者快速成长。

更多推荐