Mybatis-plus 查询的坑：com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorExceptio

2022-05-01 23:48:41.298 ERROR 21796 --- [nio-8009-exec-2] o.a.c.c.C.[.[.[/].[dispatcherServlet]    : Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception [Request processing failed; nested exception is org.springframework.jdbc.BadSqlGrammarException: 
### Error querying 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 'show FROM admin  
 WHERE id = 2' at line 1
### The error may exist in com/ny/mapper/AdminMapper.java (best guess)
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: SELECT id,password,name,level,create_time,show FROM admin    WHERE id = ?
### 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 'show FROM admin  
 WHERE id = 2' 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 'show FROM admin  
 WHERE id = 2' at line 1] with root 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 'show FROM admin  
 WHERE id = 2' at line 1
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[na:1.8.0_322]
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) ~[na:1.8.0_322]
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[na:1.8.0_322]
	at java.lang.reflect.Constructor.newInstance(Constructor.java:423) ~[na:1.8.0_322]

我们看到报错的位置：有SQL语句，我们猜测是SQL语句的问题

SELECT id,password,name,level,create_time,show FROM admin    WHERE id = ?

我们把SQL放到Navicat中查看代码，发现有点不对劲，很多字段变蓝了，就很奇怪。

我们想到把字段用模版字符串包裹起来

可以看到我们这样真的查出来了，那我们尝试使用注解改名吧，如图。

总结：数据库命名要自定义，避开特殊字段。