Annexe

Reserved words

The list bellow contains the MySQL reserved words. Thoses words should not be used as fields name (see also https://dev.mysql.com/doc/refman/5.6/en/keywords.html).

• 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

• connection

• 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

• goto

• 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

• label

• leading

• leave

• left

• like

• limit

• linear

• lines

• load

• localtime

• localtimestamp

• lock

• long

• longblob

• longtext

• loop

• low_priority

• master_ssl_verify_server_cert

• match

• 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_only

• read_write

• real

• references

• regexp

• release

• rename

• repeat

• replace

• require

• restrict

• return

• revoke

• right

• rlike

• schema

• schemas

• second_microsecond

• select

• sensitive

• separator

• set

• show

• 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

• upgrade

• usage

• use

• using

• utc_date

• utc_time

• utc_timestamp

• values

• varbinary

• varchar

• varcharacter

• varying

• when

• where

• while

• with

• write

• xor

• year_month

• zerofill