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 


파이썬(Python) 예약어

and  del  from  nonlacal  try  as  elif  global  not  while  assert  else  if  or  with  break  except  import  pass  yield  class  exec  in  print  continue  finally  is  raise  def  for  lambda  return



Java Script 예약어(reserved word)


abstract    boolean    break    byte    case    catch    char    class    const    continue    default    do    double    else    extend    false    finally    float    for    function    goto    if    implements    import    in    instanceof    int    interface    long    native    new    null    package    private    protected    public    return    short    static    super    switch    synchronized    this    throw    throws    transient    true    try    var    void    while    with


예약어란 이미 정의해 놓은 변수로써 사용자가 임의로 생성하는 변수명으로 사용할 수 없는 것이며,

모두 소문자로 이루어져 있으므로 대문자로 사용하면 예약어로 해석되지 않는다.


+ Recent posts