Created
September 12, 2018 15:56
-
-
Save bgrainger/54e7f3200772734855b08970792f0175 to your computer and use it in GitHub Desktop.
MySQL 8 reserved words
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| var reservedWords = new[] | |
| { | |
| "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", | |
| "CUBE", | |
| "CUME_DIST", | |
| "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", | |
| "DENSE_RANK", | |
| "DESC", | |
| "DESCRIBE", | |
| "DETERMINISTIC", | |
| "DISTINCT", | |
| "DISTINCTROW", | |
| "DIV", | |
| "DOUBLE", | |
| "DROP", | |
| "DUAL", | |
| "EACH", | |
| "ELSE", | |
| "ELSEIF", | |
| "EMPTY", | |
| "ENCLOSED", | |
| "ESCAPED", | |
| "EXCEPT", | |
| "EXISTS", | |
| "EXIT", | |
| "EXPLAIN", | |
| "FALSE", | |
| "FETCH", | |
| "FIRST_VALUE", | |
| "FLOAT", | |
| "FLOAT4", | |
| "FLOAT8", | |
| "FOR", | |
| "FORCE", | |
| "FOREIGN", | |
| "FROM", | |
| "FULLTEXT", | |
| "FUNCTION", | |
| "GENERATED", | |
| "GET", | |
| "GRANT", | |
| "GROUP", | |
| "GROUPING", | |
| "GROUPS", | |
| "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", | |
| "IO_AFTER_GTIDS", | |
| "IO_BEFORE_GTIDS", | |
| "IS", | |
| "ITERATE", | |
| "JOIN", | |
| "JSON_TABLE", | |
| "KEY", | |
| "KEYS", | |
| "KILL", | |
| "LAG", | |
| "LAST_VALUE", | |
| "LEAD", | |
| "LEADING", | |
| "LEAVE", | |
| "LEFT", | |
| "LIKE", | |
| "LIMIT", | |
| "LINEAR", | |
| "LINES", | |
| "LOAD", | |
| "LOCALTIME", | |
| "LOCALTIMESTAMP", | |
| "LOCK", | |
| "LONG", | |
| "LONGBLOB", | |
| "LONGTEXT", | |
| "LOOP", | |
| "LOW_PRIORITY", | |
| "MASTER_BIND", | |
| "MASTER_SSL_VERIFY_SERVER_CERT", | |
| "MATCH", | |
| "MAXVALUE", | |
| "MEDIUMBLOB", | |
| "MEDIUMINT", | |
| "MEDIUMTEXT", | |
| "MIDDLEINT", | |
| "MINUTE_MICROSECOND", | |
| "MINUTE_SECOND", | |
| "MOD", | |
| "MODIFIES", | |
| "NATURAL", | |
| "NOT", | |
| "NO_WRITE_TO_BINLOG", | |
| "NTH_VALUE", | |
| "NTILE", | |
| "NULL", | |
| "NUMERIC", | |
| "OF", | |
| "ON", | |
| "OPTIMIZE", | |
| "OPTIMIZER_COSTS", | |
| "OPTION", | |
| "OPTIONALLY", | |
| "OR", | |
| "ORDER", | |
| "OUT", | |
| "OUTER", | |
| "OUTFILE", | |
| "OVER", | |
| "PARTITION", | |
| "PERCENT_RANK", | |
| "PERSIST", | |
| "PERSIST_ONLY", | |
| "PRECISION", | |
| "PRIMARY", | |
| "PROCEDURE", | |
| "PURGE", | |
| "RANGE", | |
| "RANK", | |
| "READ", | |
| "READS", | |
| "READ_WRITE", | |
| "REAL", | |
| "RECURSIVE", | |
| "REFERENCES", | |
| "REGEXP", | |
| "RELEASE", | |
| "RENAME", | |
| "REPEAT", | |
| "REPLACE", | |
| "REQUIRE", | |
| "RESIGNAL", | |
| "RESTRICT", | |
| "RETURN", | |
| "REVOKE", | |
| "RIGHT", | |
| "RLIKE", | |
| "ROW", | |
| "ROWS", | |
| "ROW_NUMBER", | |
| "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", | |
| "STORED", | |
| "STRAIGHT_JOIN", | |
| "SYSTEM", | |
| "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", | |
| "VIRTUAL", | |
| "WHEN", | |
| "WHERE", | |
| "WHILE", | |
| "WINDOW", | |
| "WITH", | |
| "WRITE", | |
| "XOR", | |
| "YEAR_MONTH", | |
| "ZEROFILL", | |
| }; |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment