网上找的,作了修改,补充了一些没有显示的关键字,应该是网上最全面的,后期只要用mysql还会做持续的补充完善。
#TITLE=MySQL
#DELIMITER=<>/="'%,.(){}[]+*~&|;
#QUOTATION1='
#QUOTATION2=`
#CONTINUE_QUOTE=n
#LINECOMMENT=--
#LINECOMMENT=#
#COMMENTON=/*
#COMMENTOFF=*/
#PREFIX3=@
#CASE=n
#NUMBER_PATTERN=cpp
#KEYWORD=Reserved words
AS
AVG
BETWEEN
BY
CASE
CLOSE
COUNT
CREATE
DATABASE
DAY
DECODE
DELETE
DISTINCT
DROP
ELSE
END
FIRST
FOR
FROM
GROUP
HAVING
IN
INSERT
INTO
JOIN
LENGTH
LIKE
LOAD
MAX
MIN
MONTH
NULL
ON
SELECT
SET
SUBSTRING
SUM
TABLE
THEN
TO
TRIM
UPDATE
VALUES
WEEKDAY
WHEN
WHERE
COMMENT
FOREIGN_KEY_CHECKS
STRUCTURE
IF
EXISTS
CURRENT_TIMESTAMP
PRIMARY
ENGIN
KEY
UTF-8
ALTER
ADD
CONSTRAINT
FOREIGN
REFERENCES
UNIQUE
INDEX
DESC
COLUMNS
DESCRIBE
USE
#KEYWORD=Operator
:=
||
OR
XOR
&&
AND
NOT
=
<=>
>=
>
<=
<
<>
!=
IS
REGEXP
|
&
<<
>>
-
+
*
/
DIV
%
MOD
^
~
!
BINARY
COLLATE
#KEYWORD=Functions
ASCII
BIN
BIT_LENGTH
CHAR
CHAR_LENGTH
CHARACTER_LENGTH
COMPRESS
CONCAT
CONCAT_WS
CONV
ELT
EXPORT_SET
FIELD
FIND_IN_SET
HEX
INSTR
LCASE
LEFT
LOAD_FILE
LOCATE
LOWER
LPAD
LTRIM
MAKE_SET
MID
OCT
OCTET_LENGTH
ORD
POSITION
QUOTE
REPEAT
REPLACE
REVERSE
RIGHT
RPAD
RTRIM
SOUNDEX
SPACE
SUBSTRING_INDEX
UCASE
UNCOMPRESS
UNCOMPRESSED_LENGTH
UNHEX
UPPER
STRCMP
ABS
ACOS
ASIN
ATAN
CEILING
COS
COT
CRC32
DEGREES
EXP
FLOOR
LN
LOG
LOG2
LOG10
PI
POW
RADIANS
RAND
ROUND
SIGN
SIN
SQRT
TAN
TRUNCATE
ADDDATE
DATE_ADD
ADDTIME
CONVERT_TZ
CURDATE
CURRENT_DATE
CURTIME
CURRENT_TIME
DATE
DATEDIFF
DATE_FORMAT
DAYNAME
DAYOFMONTH
DAYOFWEEK
DAYOFYEAR
EXTRACT
FROM_DAYS
FROM_UNIXTIME
GET_FORMAT
HOUR
LAST_DAY
LOCALTIME
LOCALTIMESTAMP
MAKEDATE
MAKETIME
MICROSECOND
MINUTE
MONTHNAME
NOW
PERIOD_ADD
PERIOD_DIFF
QUARTER
SECOND
SEC_TO_TIME
STR_TO_DATE
SUBDATE
SUBTIME
SYSDATE
TIME
TIMEDIFF
TIMESTAMP
TIMESTAMPADD
TIMESTAMPDIFF
TIME_FORMAT
TIME_TO_SEC
TO_DAYS
UNIX_TIMESTAMP
UTC_DATE
UTC_TIME
UTC_TIMESTAMP
WEEK
WEEKOFYEAR
YEAR
YEARWEEK
AES_ENCRYPT
ENCODE
DES_DECRYPT
DES_ENCRYPT
ENCRYPT
MD5
OLD_PASSWORD
PASSWORD
SHA1
SHA
BENCHMARK
CHARSET
COERCIBILITY
COLLATION
CONNECTION_ID
CURRENT_USER
FOUND_ROWS
LAST_INSERT_ID
ROW_COUNT
SESSION_USER
SYSTEM_USER
USER
VERSION
DEFAULT
FORMAT
GET_LOCK
INET_ATON
INET_NTOA
IS_FREE_LOCK
IS_USED_LOCK
MASTER_POS_WAIT
RELEASE_LOCK
UUID
#KEYWORD=Attributes
auto_increment
unsigned
default
#KEYWORD=Literal Values
Bit
TinyInt
SmallInt
MediumInt
Int
BigInt
Float
Double
Decmical
Date
DataTime
TimeStamp
Time
Year
Char
VarChar
Binary
VarBinary
TinyText
Text
MediumText
LongText
TinyBlod
Blod
MediumBlod
LongBlod
Enum
DATETIME
#KEYWORD=Administration
OPTIMIZE
ANALYZE
CHECKSUM
FLUSH
RESET
PURGE
KILL
SHOW
ASC
BLOB
CALL
CHANGE
CHECK
CONDITION
CONTINUE
CROSS
DAY_MICROSECOND
DEC
DOUBLE
EACH
ENCLOSED
EXIT
FETCH
FLOAT8
GOTO
HOUR_MINUTE
IGNORE
INFILE
INSENSITIVE
INT1
INT4
INTERVAL
ITERATE
KEYS
LEADING
LINES
LONGBLOB
LOW_PRIORITY
MEDIUMINT
MINUTE_MICROSECOND
MODIFIES
NO_WRITE_TO_BINLOG
OPTIONALLY
OUT
PRECISION
READ
RENAME
REQUIRE
REVOKE
SCHEMA
SPATIAL
SQLEXCEPTION
SQL_BIG_RESULT
SSL
TINYBLOB
TRUE
USING
VARCHAR
WITH
ALL
ASENSITIVE
BIGINT
BOTH
CASCADE
CONNECTION
CONVERT
DATABASES
DAY_MINUTE
DECIMAL
DELAYED
DISTINCTROW
ESCAPED
EXPLAIN
FLOAT
GRANT
HIGH_PRIORITY
HOUR_SECOND
INNER
INT2
INT8
LEAVE
LIMIT
LOCK
LONGTEXT
MATCH
MEDIUMTEXT
MINUTE_SECOND
NATURAL
OUTER
RAID0
READS
RESTRICT
SCHEMAS
SENSITIVE
SPECIFIC
SQLSTATE
SQL_CALC_FOUND_ROWS
STARTING
TERMINATED
TINYINT
TRAILING
UNDO
UNLOCK
USAGE
VARCHARACTER
WRITE
YEAR_MONTH
BEFORE
CHARACTER
COLUMN
CURSOR
DAY_HOUR
DAY_SECOND
DECLARE
DETERMINISTIC
DUAL
ELSEIF
FALSE
FLOAT4
FORCE
FULLTEXT
HOUR_MICROSECOND
INOUT
INT
INT3
INTEGER
LABEL
LINEAR
LONG
LOOP
MEDIUMBLOB
MIDDLEINT
NUMERIC
OPTION
ORDER
OUTFILE
PROCEDURE
RANGE
REAL
RELEASE
RETURN
RLIKE
SECOND_MICROSECOND
SEPARATOR
SMALLINT
SQL
SQLWARNING
SQL_SMALL_RESULT
STRAIGHT_JOIN
TINYTEXT
TRIGGER
UNION
UNSIGNED
VARBINARY
VARYING
WHILE
X509
ZEROFILL
#