SQL MYSQL RESERVED WORDS
เป็นคำสงวนที่ห้ามใช้ ในฐานข้อมูล MySQL หรือสามารถใช้โดยการครอบด้วยเครื่องหมาย `wording`
Database :
MySQL,
Syntax
SELECT * FROM `order` ....
คำสงวนทั้งหมด
|
ACCESSIBLE |
ADD |
ALL |
ALTER |
ANALYZE |
AND |
AS |
ASC |
ASENSITIVE |
BEFORE |
BETWEEN |
BIGINT |
BINARY |
BLOB |
BOTH |
BY |
CALL |
CASCADE |
CASE |
CHANGE |
CHAR |
CHARACTER |
CHECK |
COLLATE |
COLUMN |
CONDITION |
CONSTRAINT |
CONTINUE |
CONVERT |
CREATE |
CROSS |
CURRENT_DATE |
CURRENT_TIME |
CURRENT_TIMESTAMP |
CURRENT_USER |
CURSOR |
DATABASE |
DATABASES |
DAY_HOUR |
DAY_MICROSECOND |
DAY_MINUTE |
DAY_SECOND |
DEC |
DECIMAL |
DECLARE |
DEFAULT |
DELAYED |
DELETE |
DESC |
DESCRIBE |
DETERMINISTIC |
DISTINCT |
DISTINCTROW |
DIV |
DOUBLE |
DROP |
DUAL |
EACH |
ELSE |
ELSEIF |
ENCLOSED |
ESCAPED |
EXISTS |
EXIT |
EXPLAIN |
FALSE |
FETCH |
FLOAT |
FLOAT4 |
FLOAT8 |
FOR |
FORCE |
FOREIGN |
FROM |
FULLTEXT |
GRANT |
GROUP |
HAVING |
HIGH_PRIORITY |
HOUR_MICROSECOND |
HOUR_MINUTE |
HOUR_SECOND |
IF |
IGNORE |
IN |
INDEX |
INFILE |
INNER |
INOUT |
INSENSITIVE |
INSERT |
INT |
INT1 |
INT2 |
INT3 |
INT4 |
INT8 |
INTEGER |
INTERVAL |
INTO |
IS |
ITERATE |
JOIN |
KEY |
KEYS |
KILL |
LEADING |
LEAVE |
LEFT |
LIKE |
LIMIT |
LINEAR |
LINES |
LOAD |
LOCALTIME |
LOCALTIMESTAMP |
LOCK |
LONG |
LONGBLOB |
LONGTEXT |
LOOP |
LOW_PRIORITY |
MASTER_SSL_VERIFY_SERVER_CERT |
MATCH |
MAXVALUE |
MEDIUMBLOB |
MEDIUMINT |
MEDIUMTEXT |
MIDDLEINT |
MINUTE_MICROSECOND |
MINUTE_SECOND |
MOD |
MODIFIES |
NATURAL |
NOT |
NO_WRITE_TO_BINLOG |
NULL |
NUMERIC |
ON |
OPTIMIZE |
OPTION |
OPTIONALLY |
OR |
ORDER |
OUT |
OUTER |
OUTFILE |
PRECISION |
PRIMARY |
PROCEDURE |
PURGE |
RANGE |
READ |
READS |
READ_WRITE |
REAL |
REFERENCES |
REGEXP |
RELEASE |
RENAME |
REPEAT |
REPLACE |
REQUIRE |
RESIGNAL |
RESTRICT |
RETURN |
REVOKE |
RIGHT |
RLIKE |
SCHEMA |
SCHEMAS |
SECOND_MICROSECOND |
SELECT |
SENSITIVE |
SEPARATOR |
SET |
SHOW |
SIGNAL |
SMALLINT |
SPATIAL |
SPECIFIC |
SQL |
SQLEXCEPTION |
SQLSTATE |
SQLWARNING |
SQL_BIG_RESULT |
SQL_CALC_FOUND_ROWS |
SQL_SMALL_RESULT |
SSL |
STARTING |
STRAIGHT_JOIN |
TABLE |
TERMINATED |
THEN |
TINYBLOB |
TINYINT |
TINYTEXT |
TO |
TRAILING |
TRIGGER |
TRUE |
UNDO |
UNION |
UNIQUE |
UNLOCK |
UNSIGNED |
UPDATE |
USAGE |
USE |
USING |
UTC_DATE |
UTC_TIME |
UTC_TIMESTAMP |
VALUES |
VARBINARY |
VARCHAR |
VARCHARACTER |
VARYING |
WHEN |
WHERE |
WHILE |
WITH |
WRITE |
XOR |
YEAR_MONTH |
ZEROFILL |
|
|
สำหรับ SQL กรณีที่ต้องการนำไปใช้create database mytest; use mytest; create table reserved_words (reserved_word varchar(50)); create index reserved_words_1ix on reserved_words(reserved_word); insert into reserved_words (reserved_word) values ('ACCESSIBLE'), ('ALTER'), ('AS'), ('BEFORE'), ('BINARY'), ('BY'), ('CASE'), ('CHARACTER'), ('COLUMN'), ('CONTINUE'), ('CROSS'), ('CURRENT_TIMESTAMP'), ('DATABASE'), ('DAY_MICROSECOND'), ('DEC'), ('DEFAULT'), ('DESC'), ('DISTINCT'), ('DOUBLE'), ('EACH'), ('ENCLOSED'), ('EXIT'), ('FETCH'), ('FLOAT8'), ('FOREIGN'), ('GRANT'), ('HIGH_PRIORITY'), ('HOUR_SECOND'), ('IN'), ('INNER'), ('INSERT'), ('INT2'), ('INT8'), ('INTO'), ('JOIN'), ('KILL'), ('LEFT'), ('LINEAR'), ('LOCALTIME'), ('LONG'), ('LOOP'), ('MATCH'), ('MEDIUMTEXT'), ('MINUTE_SECOND'), ('NATURAL'), ('NULL'), ('OPTIMIZE'), ('OR'), ('OUTER'), ('PRIMARY'), ('RANGE'), ('READ_WRITE'), ('REGEXP'), ('REPEAT'), ('RESTRICT'), ('RIGHT'), ('SCHEMAS'), ('SENSITIVE'), ('SHOW'), ('SPECIFIC'), ('SQLSTATE'), ('SQL_CALC_FOUND_ROWS'), ('STARTING'), ('TERMINATED'), ('TINYINT'), ('TRAILING'), ('UNDO'), ('UNLOCK'), ('USAGE'), ('UTC_DATE'), ('VALUES'), ('VARCHARACTER'), ('WHERE'), ('WRITE'), ('ZEROFILL'), ('ALL'), ('AND'), ('ASENSITIVE'), ('BIGINT'), ('BOTH'), ('CASCADE'), ('CHAR'), ('COLLATE'), ('CONSTRAINT'), ('CREATE'), ('CURRENT_TIME'), ('CURSOR'), ('DAY_HOUR'), ('DAY_SECOND'), ('DECLARE'), ('DELETE'), ('DETERMINISTIC'), ('DIV'), ('DUAL'), ('ELSEIF'), ('EXISTS'), ('FALSE'), ('FLOAT4'), ('FORCE'), ('FULLTEXT'), ('HAVING'), ('HOUR_MINUTE'), ('IGNORE'), ('INFILE'), ('INSENSITIVE'), ('INT1'), ('INT4'), ('INTERVAL'), ('ITERATE'), ('KEYS'), ('LEAVE'), ('LIMIT'), ('LOAD'), ('LOCK'), ('LONGTEXT'), ('MASTER_SSL_VERIFY_SERVER_CERT'), ('MEDIUMINT'), ('MINUTE_MICROSECOND'), ('MODIFIES'), ('NO_WRITE_TO_BINLOG'), ('ON'), ('OPTIONALLY'), ('OUT'), ('PRECISION'), ('PURGE'), ('READS'), ('REFERENCES'), ('RENAME'), ('REQUIRE'), ('REVOKE'), ('SCHEMA'), ('SELECT'), ('SET'), ('SPATIAL'), ('SQLEXCEPTION'), ('SQL_BIG_RESULT'), ('SSL'), ('TABLE'), ('TINYBLOB'), ('TO'), ('TRUE'), ('UNIQUE'), ('UPDATE'), ('USING'), ('UTC_TIMESTAMP'), ('VARCHAR'), ('WHEN'), ('WITH'), ('YEAR_MONTH'), ('ADD'), ('ANALYZE'), ('ASC'), ('BETWEEN'), ('BLOB'), ('CALL'), ('CHANGE'), ('CHECK'), ('CONDITION'), ('CONVERT'), ('CURRENT_DATE'), ('CURRENT_USER'), ('DATABASES'), ('DAY_MINUTE'), ('DECIMAL'), ('DELAYED'), ('DESCRIBE'), ('DISTINCTROW'), ('DROP'), ('ELSE'), ('ESCAPED'), ('EXPLAIN'), ('FLOAT'), ('FOR'), ('FROM'), ('GROUP'), ('HOUR_MICROSECOND'), ('IF'), ('INDEX'), ('INOUT'), ('INT'), ('INT3'), ('INTEGER'), ('IS'), ('KEY'), ('LEADING'), ('LIKE'), ('LINES'), ('LOCALTIMESTAMP'), ('LONGBLOB'), ('LOW_PRIORITY'), ('MEDIUMBLOB'), ('MIDDLEINT'), ('MOD'), ('NOT'), ('NUMERIC'), ('OPTION'), ('ORDER'), ('OUTFILE'), ('PROCEDURE'), ('READ'), ('REAL'), ('RELEASE'), ('REPLACE'), ('RETURN'), ('RLIKE'), ('SECOND_MICROSECOND'), ('SEPARATOR'), ('SMALLINT'), ('SQL'), ('SQLWARNING'), ('SQL_SMALL_RESULT'), ('STRAIGHT_JOIN'), ('THEN'), ('TINYTEXT'), ('TRIGGER'), ('UNION'), ('UNSIGNED'), ('USE'), ('UTC_TIME'), ('VARBINARY'), ('VARYING'), ('WHILE'), ('XOR') ;
|