CSV Reserved Words
Reserved Words
When uploading a CSV, there are some words that should not be used as column names. Here is a list of all the reserved words:
ACCESSIBLE, ACTION, ADD, ALL, ALTER, ANALYZE, AND, AS, ASC, ASENSITIVE
BEFORE, BETWEEN, BIGINT, BINARY, BIT, 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, DATE, 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, ENUM, ESCAPED, EXISTS, EXIT, EXPLAIN,
FALSE, FETCH, FLOAT, FLOAT4, FLOAT8, FOR, FORCE, FOREIGN, FROM, FULLTEXT
GENERAL, GRANT, GROUP,
HAVING, HIGH_PRIORITY, HOUR_MICROSECOND, HOUR_MINUTE, HOUR_SECOND
IF, IGNORE, IGNORE_SERVER_IDS, 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_HEARTBEAT_PERIOD, MASTER_SSL_VERIFY_SERVER_CERT, MATCH, MAXVALUE, MEDIUMBLOB, MEDIUMINT, MEDIUMTEXT, MIDDLEINT, MINUTE_MICROSECOND, MINUTE_SECOND, MOD, MODIFIES
NATURAL, NO, 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, RELEASERENAME, REPEAT, REPLACE, REQUIRE, RESIGNAL, RESTRICTRETURN, REVOKE, RIGHT, RLIKE
SCHEMA, SCHEMAS, SECOND_MICROSECOND, SELECT, SENSITIVE, SEPARATOR, SET, SHOW, SIGNAL, SLOW, SMALLINT, SORT, SPATIAL, SPECIFIC, SQL, SQLEXCEPTION, SQLSTATE, SQLWARNING, SQL_BIG_RESULT, SQL_CALC_FOUND_ROWS, SQL_SMALL_RESULT, SSL, STARTING, STRAIGHT_JOIN
TABLE, TERMINATED, TEXT, THEN, TIME, TIMESTAMP, TINYBLOB, TINYINT, TINYTEXT, TO, TRAILING, TRIGGER, TRUE, TYPE
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
