通用 mapper mybatis 插入数据报错

使用 mybatis 和 mapper 插入数据时总是失败，检查了数据库和 mybatis 配置都没有问题...

贴一下错误信息：

This application has no explicit mapping for /error, so you are seeing this as a fallback.

Tue Feb 25 20:30:06 CST 2020
There was an unexpected error (type=Internal Server Error, status=500).
### 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 "desc,like_count,lookup_count,comment_count,user_id,tag,cover_image,recommend,cre" at line 1 ### The error may exist in com/tzs/blog/mapper/ArticleMapper.java (best guess) ### The error may involve com.tzs.blog.mapper.ArticleMapper.insertSelective-Inline ### The error occurred while setting parameters ### SQL: INSERT INTO article ( id,title,desc,like_count,lookup_count,comment_count,user_id,tag,cover_image,recommend,create_time,type,content ) 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 "desc,like_count,lookup_count,comment_count,user_id,tag,cover_image,recommend,cre" 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 MySQL server version for the right syntax to use near "desc,like_count,lookup_count,comment_count,user_id,tag,cover_image,recommend,cre" at line 1

意思就是 SQL 语句语法错误，请检查你的 MySQL 版本...

搞了半个小时才发现原因，我 一张表中有个字段是 desc ，这和 MySQL 的关键字 desc 倒序重复了！改成 description 之后成功了~

不得不说，是真的迷。