postman报500错误的可能解决方案（idea报You have an error in your SQL syntax）

笔者在写springboot+微信小程序时，在进行增加数据操作时，遇到了报500错误。

分别可能是两种原因导致的

第一个是sql语句中没有加反引号。

 第二个是错误的把反引号用成了单引号，这个出现错误后如果不仔细的话非常难以检查出来

利用postman发送json也会报错（500）

 idea报错：

### Error updating database.  Cause: java.sql.SQLSyntaxErrorException: 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 ''name', 'grade', 'sex', 'phone') VALUES ('小月',null, '女', '123456')' at line 1
### The error may exist in com/webmaster/demo/mapper/UserMapper.java (best guess)
### The error may involve com.webmaster.demo.mapper.UserMapper.save-Inline
### The error occurred while setting parameters
### SQL: INSERT INTO user ('name', 'grade', 'sex', 'phone') VALUES (?,?, ?, ?);
### Cause: java.sql.SQLSyntaxErrorException: 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 ''name', 'grade', 'sex', 'phone') VALUES ('小月',null, '女', '123456')' at line 1
; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: 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 ''name', 'grade', 'sex', 'phone') VALUES ('小月',null, '女', '123456')' at line 1] with root cause

sql报错：

You have an error in your SQL syntax

解决方案是使用反引号（tab键上面的），替代单引号