去除严格模式:
vi /etc/my.cnf
最后加入或者修改成
sql_mode=NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
---------------
本文汇总MYSQL保留字一览表,方便参考
在列、表命名时候需要注意不要使用这些保留字。文中所列内容有个特殊的地方,就是有几个符号是被ANSI SQL禁止的,但仍然可以被 MySQL 用于列/表名。这是由于用他们命名符合使用习惯并已经有很多人在使用了它们。可用于MYSQL列/表名的如下即可特殊单词:ACTION/BIT /DATE /ENUM /NO /TEXT /TIME /TIMESTAMP/。
MySQL的系统保留字一览表
保留字 | 保留字 | 保留字 |
ADD | ALL | ALTER |
ANALYZE | AND | AS |
ASC | AUTO_INCREMENT | BDB |
BEFORE | BERKELEYDB | BETWEEN |
BIGINT | BINARY | BLOB |
BOTH | BTREE | BY |
CASCADE | CASE | CHANGE |
CHAR | CHARACTER | CHECK |
COLLATE | COLUMN | COLUMNS |
CONSTRAINT | CREATE | CROSS |
CURRENT_DATE | CURRENT_TIME | CURRENT_TIMESTAMP |
DATABASE | DATABASES | DAY_HOUR |
DAY_MINUTE | DAY_SECOND | DEC |
DECIMAL | DEFAULT | DELAYED |
DELETE | DESC | DESCRIBE |
DISTINCT | DISTINCTROW | DIV |
DOUBLE | DROP | ELSE |
ENCLOSED | ERRORS | ESCAPED |
EXISTS | EXPLAIN | FALSE |
FIELDS | FLOAT | FOR |
FORCE | FOREIGN | FROM |
FULLTEXT | FUNCTION | GRANT |
GROUP | HASH | HAVING |
HIGH_PRIORITY | HOUR_MINUTE | HOUR_SECOND |
IF | IGNORE | IN |
INDEX | INFILE | INNER |
INNODB | INSERT | INT |
INTEGER | INTERVAL | INTO |
IS | JOIN | KEY |
KEYS | KILL | LEADING |
LEFT | LIKE | LIMIT |
LINES | LOAD | LOCALTIME |
LOCALTIMESTAMP | LOCK | LONG |
LONGBLOB | LONGTEXT | LOW_PRIORITY |
MASTER_SERVER_ID | MATCH | MEDIUMBLOB |
MEDIUMINT | MEDIUMTEXT | MIDDLEINT |
MINUTE_SECOND | MOD | MRG_MYISAM |
NATURAL | NOT | NULL |
NUMERIC | ON | OPTIMIZE |
OPTION | OPTIONALLY | OR |
ORDER | OUTER | OUTFILE |
PRECISION | PRIMARY | PRIVILEGES |
PROCEDURE | PURGE | READ |
REAL | REFERENCES | REGEXP |
RENAME | REPLACE | REQUIRE |
RESTRICT | RETURNS | REVOKE |
RIGHT | RLIKE | RTREE |
SELECT | SET | SHOW |
SMALLINT | SOME | SONAME |
SPATIAL | SQL_BIG_RESULT | SQL_CALC_FOUND_ROWS |
SQL_SMALL_RESULT | SSL | STARTING |
STRAIGHT_JOIN | STRIPED | TABLE |
TABLES | TERMINATED | THEN |
TINYBLOB | TINYINT | TINYTEXT |
TO | TRAILING | TRUE |
TYPES | UNION | UNIQUE |
UNLOCK | UNSIGNED | UPDATE |
USAGE | USE | USER_RESOURCES |
USING | VALUES | VARBINARY |
VARCHAR | VARCHARACTER | VARYING |
WARNINGS | WHEN | WHERE |
WITH | WRITE | XOR |
YEAR_MONTH | ZEROFILL | |
本文参考资料:MYSQL官方