MySQL的保留关键字,使用时尽量避免

来源:互联网 发布:淘宝开车精灵怎么样 编辑:程序博客网 时间:2024/06/05 22:59

从网上找了一个mysql的保留字列表,仅供参考

ADD ALL ALTERANALYZE AND ASASC ASENSITIVE  BEFOREBETWEEN BIGINT  BINARYBLOB    BOTH    BYCALL    CASCADE CASECHANGE  CHAR    CHARACTERCHECK   COLLATE COLUMNCONDITION   CONNECTION  CONSTRAINTCONTINUE    CONVERT CREATECROSS   CURRENT_DATE    CURRENT_TIMECURRENT_TIMESTAMP   CURRENT_USER    CURSORDATABASE    DATABASES   DAY_HOURDAY_MICROSECOND DAY_MINUTE  DAY_SECONDDEC DECIMAL DECLAREDEFAULT DELAYED DELETEDESC    DESCRIBE    DETERMINISTICDISTINCT    DISTINCTROW DIVDOUBLE  DROP    DUALEACH    ELSE    ELSEIFENCLOSED    ESCAPED EXISTSEXIT    EXPLAIN FALSEFETCH   FLOAT   FLOAT4FLOAT8  FOR FORCEFOREIGN FROM    FULLTEXTGOTO    GRANT   GROUPHAVING  HIGH_PRIORITY   HOUR_MICROSECONDHOUR_MINUTE HOUR_SECOND IFIGNORE  IN  INDEXINFILE  INNER   INOUTINSENSITIVE INSERT  INTINT1    INT2    INT3INT4    INT8    INTEGERINTERVAL    INTO    ISITERATE JOIN    KEYKEYS    KILL    LABELLEADING LEAVE   LEFTLIKE    LIMIT   LINEARLINES   LOAD    LOCALTIMELOCALTIMESTAMP  LOCK    LONGLONGBLOB    LONGTEXT    LOOPLOW_PRIORITY    MATCH   MEDIUMBLOBMEDIUMINT   MEDIUMTEXT  MIDDLEINTMINUTE_MICROSECOND  MINUTE_SECOND   MODMODIFIES    NATURAL NOTNO_WRITE_TO_BINLOG  NULL    NUMERICON  OPTIMIZE    OPTIONOPTIONALLY  OR  ORDEROUT OUTER   OUTFILEPRECISION   PRIMARY PROCEDUREPURGE   RAID0   RANGEREAD    READS   REALREFERENCES  REGEXP  RELEASERENAME  REPEAT  REPLACEREQUIRE RESTRICT    RETURNREVOKE  RIGHT   RLIKESCHEMA  SCHEMAS SECOND_MICROSECONDSELECT  SENSITIVE   SEPARATORSET SHOW    SMALLINTSPATIAL SPECIFIC    SQLSQLEXCEPTION    SQLSTATE    SQLWARNINGSQL_BIG_RESULT  SQL_CALC_FOUND_ROWS SQL_SMALL_RESULTSSL STARTING    STRAIGHT_JOINTABLE   TERMINATED  THENTINYBLOB    TINYINT TINYTEXTTO  TRAILING    TRIGGERTRUE    UNDO    UNIONUNIQUE  UNLOCK  UNSIGNEDUPDATE  USAGE   USEUSING   UTC_DATE    UTC_TIMEUTC_TIMESTAMP   VALUES  VARBINARYVARCHAR VARCHARACTER    VARYINGWHEN    WHERE   WHILEWITH    WRITE   X509XOR YEAR_MONTH  ZEROFILL
0 0
原创粉丝点击