There is a problem when adding, deleting, modifying and querying the interface of a table, as shown in figure
Error codes are as follows:
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 'DESCRIBE , CREATE_TIME,
CREATED, UPDATE_TIME, UPDATED
from renew_rul' at line 3
; bad SQL grammar []; nested exception is 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 'DESCRIBE , CREATE_TIME,
CREATED, UPDATE_TIME, UPDATED
from renew_rul' at line 3
Prompt me that my SQL syntax is abnormal. I have searched the Internet for a long time, but I haven’t found a similar problem. I specially record it,
The database used is MySQL and the database graphical interface Navicat.
The reason for the problem is that description is a keyword, which needs further processing in mybatis, but it’s strange that status should also be a keyword. Why doesn’t it report an error?
Solution: change the description field to des so that it can be compiled.
Read More:
- You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version
- Error querying database.Cause:java.sql.SQLSyntaxErrorException:ORA-00911:invalid character
- An error is reported about import Java. SQL. *; problem
- This function has none of deterministic, no SQL, or reads SQL data in its error records
- SQL state [null]; error code [0]; Error; nested exception is java.sql.SQLException: Error] with root
- Spring data JAP SQL error:17059 SQL State:99999
- Cause: java.sql.BatchUpdateException: Unknown column ‘xxx‘ in ‘field list‘
- Hive SQL syntax error and corresponding solutions
- SQL 2005 remote connection error (provider: SQL network interface, error: 28 – the server does not support the requested protocol
- SAP SQL error “SQL code: -10692“ occurred while accessing table “ZTXXXX“.
- DB2 SQL ERROR: SQLCODE=-803, SQLSTATE=23505, SQL
- Cause: java.sql.SQLException: Error setting driver on UnpooledDataSource. Cause: java.lang.ClassNot
- Java 11.0.11 SQL Server connection error
- java.sql.SQLException: Incorrect string value:
- com.alibaba.druid.sql.parser.ParserException: syntax error
- java.sql.SQLRecoverableException: IO Error: Connection reset
- Error: globalconfigutils setmetadata fail! Cause:java.sql.SQLException…
- MySql 8.x java.sql.SQLNonTransientConnectionException: Public Key Retrieval is not allowed
- Error attempting to get column time from result set. Cause: java.sql.SQLFe
- java.sql.SQLException : IO error: socket read timed out!