### The error may exist in com/xjh/mange/mapper/WebMapper.java (best guess) ### The error may involv
The error may exist in com/xjh/mange/mapper/WebMapper.java (best guess)The error may involve com.xjh.mange.mapper.WebMapper.insert-InlineThe error occurred while setting parametersSQL: INSERT INTO web
·
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会把关键字会转换为大写蓝色,一眼就能看到
更多推荐
已为社区贡献1条内容
所有评论(0)