MySQL Reserved Words

MySQL doc 링크

 Reserved Words in MySQL 5.6.22

ACCESSIBLEADDALL
ALTERANALYZEAND
ASASCASENSITIVE
BEFOREBETWEENBIGINT
BINARYBLOBBOTH
BYCALLCASCADE
CASECHANGECHAR
CHARACTERCHECKCOLLATE
COLUMNCONDITIONCONSTRAINT
CONTINUECONVERTCREATE
CROSSCURRENT_DATECURRENT_TIME
CURRENT_TIMESTAMPCURRENT_USERCURSOR
DATABASEDATABASESDAY_HOUR
DAY_MICROSECONDDAY_MINUTEDAY_SECOND
DECDECIMALDECLARE
DEFAULTDELAYEDDELETE
DESCDESCRIBEDETERMINISTIC
DISTINCTDISTINCTROWDIV
DOUBLEDROPDUAL
EACHELSEELSEIF
ENCLOSEDESCAPEDEXISTS
EXITEXPLAINFALSE
FETCHFLOATFLOAT4
FLOAT8FORFORCE
FOREIGNFROMFULLTEXT
GETGRANTGROUP
HAVINGHIGH_PRIORITYHOUR_MICROSECOND
HOUR_MINUTEHOUR_SECONDIF
IGNOREININDEX
INFILEINNERINOUT
INSENSITIVEINSERTINT
INT1INT2INT3
INT4INT8INTEGER
INTERVALINTOIO_AFTER_GTIDS
IO_BEFORE_GTIDSISITERATE
JOINKEYKEYS
KILLLEADINGLEAVE
LEFTLIKELIMIT
LINEARLINESLOAD
LOCALTIMELOCALTIMESTAMPLOCK
LONGLONGBLOBLONGTEXT
LOOPLOW_PRIORITYMASTER_BIND
MASTER_SSL_VERIFY_SERVER_CERTMATCHMAXVALUE
MEDIUMBLOBMEDIUMINTMEDIUMTEXT
MIDDLEINTMINUTE_MICROSECONDMINUTE_SECOND
MODMODIFIESNATURAL
NOTNO_WRITE_TO_BINLOGNULL
NUMERICONOPTIMIZE
OPTIONOPTIONALLYOR
ORDEROUTOUTER
OUTFILEPARTITIONPRECISION
PRIMARYPROCEDUREPURGE
RANGEREADREADS
READ_WRITEREALREFERENCES
REGEXPRELEASERENAME
REPEATREPLACEREQUIRE
RESIGNALRESTRICTRETURN
REVOKERIGHTRLIKE
SCHEMASCHEMASSECOND_MICROSECOND
SELECTSENSITIVESEPARATOR
SETSHOWSIGNAL
SMALLINTSPATIALSPECIFIC
SQLSQLEXCEPTIONSQLSTATE
SQLWARNINGSQL_BIG_RESULTSQL_CALC_FOUND_ROWS
SQL_SMALL_RESULTSSLSTARTING
STRAIGHT_JOINTABLETERMINATED
THENTINYBLOBTINYINT
TINYTEXTTOTRAILING
TRIGGERTRUEUNDO
UNIONUNIQUEUNLOCK
UNSIGNEDUPDATEUSAGE
USEUSINGUTC_DATE
UTC_TIMEUTC_TIMESTAMPVALUES
VARBINARYVARCHARVARCHARACTER
VARYINGWHENWHERE
WHILEWITHWRITE
XORYEAR_MONTHZEROFILL


New Reserved Words in MySQL 5.6

GETIO_AFTER_GTIDSIO_BEFORE_GTIDS
MASTER_BINDONE_SHOTPARTITION
SQL_AFTER_GTIDSSQL_BEFORE_GTIDS 


+ Recent posts