Why can’t you grab tickets when you travel on holiday?Reveal the key technology of 12306 how to ensure the ticket is not oversold>>> 
SQL error: 1064, sqlstate: 42000 error
In mysql, the words in the following table are reserved explicitly. Most of these bases are used by standard SQL as column and/or table names (for example, group). A few have been retained because MySQL needs them, using the yacc parser. A reserved word can be used as an identifier when it is raised
If you accidentally use the following keywords, you will report this error
“SQL error: 1064, sqlstate: 42000 error”
Similar Posts:
- Hive Error: Error while compiling statement: FAILED: ParseException line 1:7 Failed to recognize
- SQL Error: 1064, SQLState: 42000 [Three Methods to Solve]
- How to quickly locate problems in error reporting of db2-407 sqlcode: – 407, sqlstate: 23502
- How to quickly locate problems in error reporting of db2-407 sqlcode: – 407, sqlstate: 23502
- Treatment of MySQL database keyword as column name by mybatisplus — sqlsyntax errorexception: you have an error in your SQL syntax;
- MySQL Reading table information for completion of table and column names
- DB2 SQL Error: SQLCODE=-668, SQLSTATE=57016mistake
- DB2 SQL Error: SQLCODE=-805, SQLSTATE=51002 Resolution
- DB2 error: sqlcode = – 802, sqlstate = 22003
- mysqldump unknown table ‘column_statistics’