• 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字段命名,表名,库名应尽量避免使用关键字,真悲催,点点编辑器居然要过滤table,搞了半天弄了个UL吧

  • 相关阅读:
    Zookeeper
    激活函数
    线程池
    用rand()和srand()产生伪随机数的方法总结 (转贴)
    连接SDE数据库代码
    ProgressBar
    ArcEngine+OpenGL之二系统平台搭建
    我所知道的ArcObjects开发(转)
    oracle wm_concat函数 乱码
    修改32位的AutoCAD2012,使其能在64位系统上安装
  • 原文地址:https://www.cnblogs.com/zhouzme/p/5758533.html
Copyright © 2020-2023  润新知