开发者社区> 问答> 正文

mysql 关键字

mysql 关键字

展开
收起
李博 bluemind 2019-02-01 16:43:39 3878 0
3 条回答
写回答
取消 提交回答
  • 主要从事 Java 后端开发。

    无需特意去了解mysql关键字。 常用的关键字,你在实际开发中自然而然的会记住会使用。 至于那些你不是很了解的或者没使用过的关键字,通过平常看到的文章或者通过实际开发中遇到的问题,你会自发的去网上找,然后再使用。使用之后,你也就自然会记住了。

    所以,关键还是平常的使用和积累,不需要一次性全部了解。

    2019-07-27 10:49:42
    赞同 展开评论 打赏
  • 这个系统学习下更好,有理论,应用的时候忘记了百度下很快可以完成

    2019-07-17 23:27:36
    赞同 展开评论 打赏
  • A

    ACCESSIBLE (R)

    ACTION

    ADD (R)

    AFTER

    AGAINST

    AGGREGATE

    ALGORITHM

    ALL (R)

    ALTER (R)

    ANALYZE (R)

    AND (R)

    ANY

    AS (R)

    ASC (R)

    ASCII

    ASENSITIVE (R)

    AT

    AUTHORS

    AUTOEXTEND_SIZE

    AUTO_INCREMENT

    AVG

    AVG_ROW_LENGTH

    B

    BACKUP

    BEFORE (R)

    BEGIN

    BETWEEN (R)

    BIGINT (R)

    BINARY (R)

    BINLOG

    BIT

    BLOB (R)

    BLOCK

    BOOL

    BOOLEAN

    BOTH (R)

    BTREE

    BY (R)

    BYTE

    C

    CACHE

    CALL (R)

    CASCADE (R)

    CASCADED

    CASE (R)

    CATALOG_NAME

    CHAIN

    CHANGE (R)

    CHANGED

    CHAR (R)

    CHARACTER (R)

    CHARSET

    CHECK (R)

    CHECKSUM

    CIPHER

    CLASS_ORIGIN

    CLIENT

    CLOSE

    COALESCE

    CODE

    COLLATE (R)

    COLLATION

    COLUMN (R)

    COLUMNS

    COLUMN_NAME

    COMMENT

    COMMIT

    COMMITTED

    COMPACT

    COMPLETION

    COMPRESSED

    CONCURRENT

    CONDITION (R)

    CONNECTION

    CONSISTENT

    CONSTRAINT (R)

    CONSTRAINT_CATALOG

    CONSTRAINT_NAME

    CONSTRAINT_SCHEMA

    CONTAINS

    CONTEXT

    CONTINUE (R)

    CONTRIBUTORS

    CONVERT (R)

    CPU

    CREATE (R)

    CROSS (R)

    CUBE

    CURRENT_DATE (R)

    CURRENT_TIME (R)

    CURRENT_TIMESTAMP (R)

    CURRENT_USER (R)

    CURSOR (R)

    CURSOR_NAME

    D

    DATA

    DATABASE (R)

    DATABASES (R)

    DATAFILE

    DATE

    DATETIME

    DAY

    DAY_HOUR (R)

    DAY_MICROSECOND (R)

    DAY_MINUTE (R)

    DAY_SECOND (R)

    DEALLOCATE

    DEC (R)

    DECIMAL (R)

    DECLARE (R)

    DEFAULT (R)

    DEFINER

    DELAYED (R)

    DELAY_KEY_WRITE

    DELETE (R)

    DESC (R)

    DESCRIBE (R)

    DES_KEY_FILE

    DETERMINISTIC (R)

    DIRECTORY

    DISABLE

    DISCARD

    DISK

    DISTINCT (R)

    DISTINCTROW (R)

    DIV (R)

    DO

    DOUBLE (R)

    DROP (R)

    DUAL (R)

    DUMPFILE

    DUPLICATE

    DYNAMIC

    E

    EACH (R)

    ELSE (R)

    ELSEIF (R)

    ENABLE

    ENCLOSED (R)

    END

    ENDS

    ENGINE

    ENGINES

    ENUM

    ERROR added in 5.5.3 (nonreserved)

    ERRORS

    ESCAPE

    ESCAPED (R)

    EVENT

    EVENTS

    EVERY

    EXECUTE

    EXISTS (R)

    EXIT (R)

    EXPANSION

    EXPLAIN (R)

    EXTENDED

    EXTENT_SIZE

    F

    FALSE (R)

    FAST

    FAULTS

    FETCH (R)

    FIELDS

    FILE

    FIRST

    FIXED

    FLOAT (R)

    FLOAT4 (R)

    FLOAT8 (R)

    FLUSH

    FOR (R)

    FORCE (R)

    FOREIGN (R)

    FOUND

    FRAC_SECOND removed in 5.5.3

    FROM (R)

    FULL

    FULLTEXT (R)

    FUNCTION

    G

    GENERAL added in 5.5.3 (reserved); became nonreserved in 5.5.8

    GEOMETRY

    GEOMETRYCOLLECTION

    GET_FORMAT

    GLOBAL

    GRANT (R)

    GRANTS

    GROUP (R)

    H

    HANDLER

    HASH

    HAVING (R)

    HELP

    HIGH_PRIORITY (R)

    HOST

    HOSTS

    HOUR

    HOUR_MICROSECOND (R)

    HOUR_MINUTE (R)

    HOUR_SECOND (R)

    I

    IDENTIFIED

    IF (R)

    IGNORE (R)

    IGNORE_SERVER_IDS became nonreserved in 5.5.8

    IMPORT

    IN (R)

    INDEX (R)

    INDEXES

    INFILE (R)

    INITIAL_SIZE

    INNER (R)

    INNOBASE removed in 5.5.3

    INNODB removed in 5.5.3

    INOUT (R)

    INSENSITIVE (R)

    INSERT (R)

    INSERT_METHOD

    INSTALL

    INT (R)

    INT1 (R)

    INT2 (R)

    INT3 (R)

    INT4 (R)

    INT8 (R)

    INTEGER (R)

    INTERVAL (R)

    INTO (R)

    INVOKER

    IO

    IO_THREAD

    IPC

    IS (R)

    ISOLATION

    ISSUER

    ITERATE (R)

    J

    JOIN (R)

    K

    KEY (R)

    KEYS (R)

    KEY_BLOCK_SIZE

    KILL (R)

    L

    LANGUAGE

    LAST

    LEADING (R)

    LEAVE (R)

    LEAVES

    LEFT (R)

    LESS

    LEVEL

    LIKE (R)

    LIMIT (R)

    LINEAR (R)

    LINES (R)

    LINESTRING

    LIST

    LOAD (R)

    LOCAL

    LOCALTIME (R)

    LOCALTIMESTAMP (R)

    LOCK (R)

    LOCKS

    LOGFILE

    LOGS

    LONG (R)

    LONGBLOB (R)

    LONGTEXT (R)

    LOOP (R)

    LOW_PRIORITY (R)

    M

    MASTER

    MASTER_CONNECT_RETRY

    MASTER_HEARTBEAT_PERIOD became nonreserved in 5.5.8

    MASTER_HOST

    MASTER_LOG_FILE

    MASTER_LOG_POS

    MASTER_PASSWORD

    MASTER_PORT

    MASTER_SERVER_ID

    MASTER_SSL

    MASTER_SSL_CA

    MASTER_SSL_CAPATH

    MASTER_SSL_CERT

    MASTER_SSL_CIPHER

    MASTER_SSL_KEY

    MASTER_SSL_VERIFY_SERVER_CERT (R)

    MASTER_USER

    MATCH (R)

    MAXVALUE (R)

    MAX_CONNECTIONS_PER_HOUR

    MAX_QUERIES_PER_HOUR

    MAX_ROWS

    MAX_SIZE

    MAX_UPDATES_PER_HOUR

    MAX_USER_CONNECTIONS

    MEDIUM

    MEDIUMBLOB (R)

    MEDIUMINT (R)

    MEDIUMTEXT (R)

    MEMORY

    MERGE

    MESSAGE_TEXT

    MICROSECOND

    MIDDLEINT (R)

    MIGRATE

    MINUTE

    MINUTE_MICROSECOND (R)

    MINUTE_SECOND (R)

    MIN_ROWS

    MOD (R)

    MODE

    MODIFIES (R)

    MODIFY

    MONTH

    MULTILINESTRING

    MULTIPOINT

    MULTIPOLYGON

    MUTEX

    MYSQL_ERRNO

    N

    NAME

    NAMES

    NATIONAL

    NATURAL (R)

    NCHAR

    NDB

    NDBCLUSTER

    NEW

    NEXT

    NO

    NODEGROUP

    NONE

    NOT (R)

    NO_WAIT

    NO_WRITE_TO_BINLOG (R)

    NULL (R)

    NUMERIC (R)

    NVARCHAR

    O

    OFFSET

    OLD_PASSWORD

    ON (R)

    ONE

    ONE_SHOT

    OPEN

    OPTIMIZE (R)

    OPTION (R)

    OPTIONALLY (R)

    OPTIONS

    OR (R)

    ORDER (R)

    OUT (R)

    OUTER (R)

    OUTFILE (R)

    OWNER

    P

    PACK_KEYS

    PAGE

    PARSER

    PARTIAL

    PARTITION

    PARTITIONING

    PARTITIONS

    PASSWORD

    PHASE

    PLUGIN

    PLUGINS

    POINT

    POLYGON

    PORT

    PRECISION (R)

    PREPARE

    PRESERVE

    PREV

    PRIMARY (R)

    PRIVILEGES

    PROCEDURE (R)

    PROCESSLIST

    PROFILE

    PROFILES

    PROXY added in 5.5.7 (nonreserved)

    PURGE (R)

    Q

    QUARTER

    QUERY

    QUICK

    R

    RANGE (R)

    READ (R)

    READS (R)

    READ_ONLY

    READ_WRITE (R)

    REAL (R)

    REBUILD

    RECOVER

    REDOFILE

    REDO_BUFFER_SIZE

    REDUNDANT

    REFERENCES (R)

    REGEXP (R)

    RELAY added in 5.5.3 (nonreserved)

    RELAYLOG

    RELAY_LOG_FILE

    RELAY_LOG_POS

    RELAY_THREAD

    RELEASE (R)

    RELOAD

    REMOVE

    RENAME (R)

    REORGANIZE

    REPAIR

    REPEAT (R)

    REPEATABLE

    REPLACE (R)

    REPLICATION

    REQUIRE (R)

    RESET

    RESIGNAL (R)

    RESTORE

    RESTRICT (R)

    RESUME

    RETURN (R)

    RETURNS

    REVOKE (R)

    RIGHT (R)

    RLIKE (R)

    ROLLBACK

    ROLLUP

    ROUTINE

    ROW

    ROWS

    ROW_FORMAT

    RTREE

    S

    SAVEPOINT

    SCHEDULE

    SCHEMA (R)

    SCHEMAS (R)

    SCHEMA_NAME

    SECOND

    SECOND_MICROSECOND (R)

    SECURITY

    SELECT (R)

    SENSITIVE (R)

    SEPARATOR (R)

    SERIAL

    SERIALIZABLE

    SERVER

    SESSION

    SET (R)

    SHARE

    SHOW (R)

    SHUTDOWN

    SIGNAL (R)

    SIGNED

    SIMPLE

    SLAVE

    SLOW added in 5.5.3 (reserved); became nonreserved in 5.5.8

    SMALLINT (R)

    SNAPSHOT

    SOCKET

    SOME

    SONAME

    SOUNDS

    SOURCE

    SPATIAL (R)

    SPECIFIC (R)

    SQL (R)

    SQLEXCEPTION (R)

    SQLSTATE (R)

    SQLWARNING (R)

    SQL_BIG_RESULT (R)

    SQL_BUFFER_RESULT

    SQL_CACHE

    SQL_CALC_FOUND_ROWS (R)

    SQL_NO_CACHE

    SQL_SMALL_RESULT (R)

    SQL_THREAD

    SQL_TSI_DAY

    SQL_TSI_FRAC_SECOND removed in 5.5.3

    SQL_TSI_HOUR

    SQL_TSI_MINUTE

    SQL_TSI_MONTH

    SQL_TSI_QUARTER

    SQL_TSI_SECOND

    SQL_TSI_WEEK

    SQL_TSI_YEAR

    SSL (R)

    START

    STARTING (R)

    STARTS

    STATUS

    STOP

    STORAGE

    STRAIGHT_JOIN (R)

    STRING

    SUBCLASS_ORIGIN

    SUBJECT

    SUBPARTITION

    SUBPARTITIONS

    SUPER

    SUSPEND

    SWAPS

    SWITCHES

    T

    TABLE (R)

    TABLES

    TABLESPACE

    TABLE_CHECKSUM

    TABLE_NAME

    TEMPORARY

    TEMPTABLE

    TERMINATED (R)

    TEXT

    THAN

    THEN (R)

    TIME

    TIMESTAMP

    TIMESTAMPADD

    TIMESTAMPDIFF

    TINYBLOB (R)

    TINYINT (R)

    TINYTEXT (R)

    TO (R)

    TRAILING (R)

    TRANSACTION

    TRIGGER (R)

    TRIGGERS

    TRUE (R)

    TRUNCATE

    TYPE

    TYPES

    U

    UNCOMMITTED

    UNDEFINED

    UNDO (R)

    UNDOFILE

    UNDO_BUFFER_SIZE

    UNICODE

    UNINSTALL

    UNION (R)

    UNIQUE (R)

    UNKNOWN

    UNLOCK (R)

    UNSIGNED (R)

    UNTIL

    UPDATE (R)

    UPGRADE

    USAGE (R)

    USE (R)

    USER

    USER_RESOURCES

    USE_FRM

    USING (R)

    UTC_DATE (R)

    UTC_TIME (R)

    UTC_TIMESTAMP (R)

    V

    VALUE

    VALUES (R)

    VARBINARY (R)

    VARCHAR (R)

    VARCHARACTER (R)

    VARIABLES

    VARYING (R)

    VIEW

    W

    WAIT

    WARNINGS

    WEEK

    WHEN (R)

    WHERE (R)

    WHILE (R)

    WITH (R)

    WORK

    WRAPPER

    WRITE (R)

    X

    X509

    XA

    XML

    XOR (R)

    Y

    YEAR

    YEAR_MONTH (R)

    Z

    ZEROFILL (R)

    MySQL 5.5 New Keywords and Reserved Words
    The following list shows the keywords and reserved words that are added in MySQL 5.5, compared to MySQL 5.1. Reserved keywords are marked with (R).

    C

    CATALOG_NAME

    CLASS_ORIGIN

    COLUMN_NAME

    CONSTRAINT_CATALOG

    CONSTRAINT_NAME

    CONSTRAINT_SCHEMA

    CURSOR_NAME

    E

    ERROR

    G

    GENERAL

    I

    IGNORE_SERVER_IDS

    M

    MASTER_HEARTBEAT_PERIOD

    MESSAGE_TEXT

    MYSQL_ERRNO

    P

    PROXY

    R

    RELAY

    RELAYLOG

    RESIGNAL (R)

    S

    SCHEMA_NAME

    SIGNAL (R)

    SLOW

    SUBCLASS_ORIGIN

    T

    TABLE_NAME

    X

    XML

    MySQL 5.5 Removed Keywords and Reserved Words
    The following list shows the keywords and reserved words that are removed in MySQL 5.5, compared to MySQL 5.1. Reserved keywords are marked with (R).

    FRAC_SECOND

    INNOBASE

    INNODB

    SQL_TSI_FRAC_SECOND

    原文:https://blog.csdn.net/u011479200/article/details/78664625

    2019-07-17 23:27:36
    赞同 展开评论 打赏
问答排行榜
最热
最新

相关电子书

更多
搭建电商项目架构连接MySQL 立即下载
搭建4层电商项目架构,实战连接MySQL 立即下载
PolarDB MySQL引擎重磅功能及产品能力盛大发布 立即下载

相关镜像