Reserved fields in MySQL

Summary You have a error in your SQL syntax; Check the manual, corresponds to your MySQL server Versio This sentence for us is not unfamiliar, nothing more than "," and so on. But if you inadvertently add a reserved field in MySQL as the field name stored in the database, this tragedy happens. mysql reserved word

Catalogue [-]

• MySQL's reserved fields

 a few days ago because of temporary changes to the function, you need to add a field to the data table to differentiate the imported batches, I added the Group field to MySQL, and I didn't expect my nightmare to unfold    was already close to finishing the program, this morning to the company to the program to a happy ending, did not expect to Every time I import an Excel table that always prompts me for an SQL statement error, I change the SQL statement by adding a minus or minus, and not getting the error done, and the whole morning, plus two hours in the afternoon, is almost to the point of madness. I was trying to get down on my knees, but I didn't fix the mistake.    put the problem aside and continue to engage in other things. When writing a group by  statement, suddenly realize that,group  is a reserved word for MySQL, this problem solved. Remember, how painful the understanding AH 

MySQL's reserved fields

ADD All ALTER 
ANALYZE and AS 
ASC Asensitive before 
Between BIGINT BINARY 
BLOB BOTH by 
Call CASCADE case 
Change CHAR CHARACTER 
CHECK COLLATE COLUMN 
CONDITION CONNECTION CONSTRAINT 
CONTINUE CONVERT CREATE 
Cross Current_date Current_time 
Current_timestamp Current_User CURSOR 
DATABASE DATABASES Day_hour 
Day_microsecond Day_minute Day_second 
DEC DECIMAL DECLARE 
DEFAULT DELAYED DELETE

Reserved fields in MySQL