SQL Reserved Words

Check a word:

(type a word to check against the reserved word list)

Not Reserved (but good to avoid anyway)

action bit date enum no text time timestamp value

Reserved

add after aggregate all alter and as asc auto_increment avg avg_row_length between bigint binary blob bool both by cascade case change char character check checksum column columns comment constraint create cross current_date current_time current_timestamp data database databases datetime day day_hour day_minute day_second dayofmonth dayofweek dayofyear dec decimal default delay_key_write delayed delete desc describe distinct distinctrow double drop else enclosed end escape escaped exists explain fields file first float float4 float8 flush for foreign from full function global grant grants group having heap high_priority hosts hour hour_minute hour_second identified if ignore in index infile inner insert insert_id int int1 int2 int3 int4 int8 integer interval into is isam join key keys kill last_insert_id leading left length like limit lines load local lock log logs long longblob longtext low_priority match max max_rows mediumblob mediumint mediumtext middleint min_rows minute minute_second modify month monthname myisam natural not null numeric on optimize option optionally or order outer outfile pack_keys partial password precision primary privileges procedure process processlist read real references regexp reload rename replace restrict returns revoke rlike row rows second select set show shutdown smallint soname space sql_big_result sql_big_selects sql_big_tables sql_log_off sql_log_update sql_low_priority_updates sql_select_limit sql_small_result sql_warnings starting status straight_join string table tables temporary terminated then tinyblob tinyint tinytext to trailing type unique unlock unsigned update usage use user using values varbinary varchar variables varying when where with write year year_month zerofill