This error is because MySQL has some keywords that we use, we need to change the keyword into other names
ADD |
All |
Alter |
ANALYZE |
and |
As |
Asc |
Asensitive |
Before |
Between |
BIGINT |
BINARY |
Blob |
BOTH |
By |
Pager |
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 |
DESC |
DESCRIBE |
Deterministic |
DISTINCT |
Distinctrow |
Div |
DOUBLE |
DROP |
DUAL |
each |
ELSE |
ELSEIF |
Enclosed |
Escaped |
EXISTS |
EXIT |
EXPLAIN |
FALSE |
FETCH |
FLOAT |
FLOAT4 |
FLOAT8 |
For |
Force |
FOREIGN |
From |
Fulltext |
Goto |
GRANT |
GROUP |
Having |
High_priority |
Hour_microsecond |
Hour_minute |
Hour_second |
IF |
IGNORE |
Inch |
INDEX |
INFILE |
INNER |
INOUT |
Insensitive |
INSERT |
Int |
INT1 |
INT2 |
INT3 |
INT4 |
INT8 |
INTEGER |
INTERVAL |
Into |
Is |
Iterate |
JOIN |
KEY |
KEYS |
KILL |
LABEL |
Leading |
LEAVE |
Left |
Like |
LIMIT |
LINEAR |
LINES |
LOAD |
LocalTime |
Localtimestamp |
LOCK |
LONG |
Longblob |
Longtext |
LOOP |
Low_priority |
MATCH |
Mediumblob |
Mediumint |
Mediumtext |
Middleint |
Minute_microsecond |
Minute_second |
MOD |
Modifies |
NATURAL |
Not |
No_write_to_binlog |
Null |
NUMERIC |
On |
OPTIMIZE |
OPTION |
Optionally |
OR |
ORDER |
Out |
OUTER |
OUTFILE |
PRECISION |
PRIMARY |
PROCEDURE |
PURGE |
RAID0 |
RANGE |
READ |
READS |
REAL |
REFERENCES |
Regexp |
RELEASE |
RENAME |
REPEAT |
REPLACE |
REQUIRE |
RESTRICT |
RETURN |
REVOKE |
Right |
Rlike |
SCHEMA |
SCHEMAS |
Second_microsecond |
SELECT |
Sensitive |
SEPARATOR |
SET |
SHOW |
SMALLINT |
SPATIAL |
Specific |
Sql |
SQLEXCEPTION |
SQLSTATE |
SQLWarning |
Sql_big_result |
Sql_calc_found_rows |
Sql_small_result |
Ssl |
Starting |
Straight_join |
TABLE |
TERMINATED |
Then |
Tinyblob |
TINYINT |
Tinytext |
To |
TRAILING |
TRIGGER |
TRUE |
UNDO |
UNION |
UNIQUE |
UNLOCK |
UNSIGNED |
UPDATE |
USAGE |
Use |
USING |
Utc_date |
Utc_time |
Utc_timestamp |
VALUES |
VARBINARY |
VARCHAR |
Varcharacter |
VARYING |
When |
WHERE |
While |
With |
WRITE |
X509 |
Xor |
Year_month |
Zerofill |
SQL error:1064, sqlstate:42000