# # # Error querying the database. Cause: dm.. JDBC driver. DMException: line 1, column 186 near/ADMIN Error:
Syntax error analysis
# # # The error may exist in The com/toptime/mapper/AdminMapper. Java (best guess)
# # # The error may involve com. Toptime. Mapper. AdminMapper. SelectList
# # # The error occurred while executing a query
# # # SQL: SELECT ID, ISLOCK, TRUENAME, CREATETIME, ADMINNAME, LASTERRLOGINTIME, MAIL, ISBUILTIN, LOGINTIMES, LASTLOGINIP, MOBILE, LASTLOGINTIME, LOGINERRTIMES, ADMINPASS, LOGINMSGCHECK, STATUS, LASTMODIFY FROM ADMIN
# # # Cause: dm, the JDBC driver. DMException: line 1, column 186 near/ADMIN error:
Syntax error analysis
; Bad SQL grammar []; Nested exception is dm, the JDBC driver. DMException: line 1, column 186 near/ADMIN error:
Syntax error analysis
================================================
Query to this wrong, but put the SQL statement alone in dream database management tools on the show that can add double quotation marks, this is mybatisplus + springboot project, I have seen online mybatisplus have database with the support of dream
CodePudding user response:
CodePudding user response:
ADMIN is a key word of the dream, shielding, or in dm_svc. Need to use double quotation marks the conf file configuration corresponding keyword blocking,