hi,欢迎访问本站!
当前位置: 首页数据库正文

mysql中系统关键字汇总

墨初 数据库 506阅读

在书写sql语句时,如果表的字段与mysql语句中的关键字发生了冲突,就会抛出“SQL Error: 1064, SQLState: 42000错误”,为了避免此错误的产生,我们需要熟记mysql语句中的一些常用的关键词,下面博文中列出了一些mysql中的关键字,供大家参考。

mysql语句关键词冲突错误

SQL Error: 1064, SQLState: 42000错误

MySQL server version for the right syntax to use near

mysql 系统关键字汇总列表

ADDALL
ALTERANALYZE
ANDAS
ASCASENSITIVE
BEFOREBETWEEN
BIGINTBINARY
BLOBBOTH
BYCALL
CASCADECASE
CHANGECHAR
CHARACTERCHECK
COLLATECOLUMN
CONDITIONCONNECTION
CONSTRAINTCONTINUE
CONVERTCREATE
CROSSCURRENT_DATE
CURRENT_TIMECURRENT_TIMESTAMP
CURRENT_USERCURSOR
DATABASEDATABASES
DAY_HOURDAY_MICROSECOND
DAY_MINUTEDAY_SECOND
DECDECIMAL
DECLAREDEFAULT
DELAYEDDELETE
DESCDESCRIBE
DETERMINISTICDISTINCT
DISTINCTROWDIV
DOUBLEDROP
DUALEACH
ELSEELSEIF
ENCLOSEDESCAPED
EXISTSEXIT
EXPLAINFALSE
FETCHFLOAT
FLOAT4FLOAT8
FORFORCE
FOREIGNFROM
FULLTEXTGOTO
GRANTGROUP
HAVINGHIGH_PRIORITY
HOUR_MICROSECONDHOUR_MINUTE
HOUR_SECONDIF
IGNOREIN
INDEXINFILE
INNERINOUT
INSENSITIVEINSERT
INTINT1
INT2INT3
INT4INT8
INTEGERINTERVAL
INTOIS
ITERATEJOIN
KEYKEYS
KILLLABEL
LEADINGLEAVE
LEFTLIKE
LIMITLINEAR
LINESLOAD
LOCALTIMELOCALTIMESTAMP
LOCKLONG
LONGBLOBLONGTEXT
LOOPLOW_PRIORITY
MATCHMEDIUMBLOB
MEDIUMINTMEDIUMTEXT
MIDDLEINTMINUTE_MICROSECOND
MINUTE_SECONDMOD
MODIFIESNATURAL
NOTNO_WRITE_TO_BINLOG
NULLNUMERIC
NUMERICON
OPTIMIZEOPTION
OPTIONALLYOR
ORDEROUT
OUTEROUTFILE
PRECISIONPRIMARY
PROCEDUREPURGE
RAID0RANGE
READREADS
REALREFERENCES
REGEXPRELEASE
RENAMEREPEAT
REPLACEREQUIRE
RESTRICTRETURN
REVOKERIGHT
RLIKESCHEMA
SCHEMASSECOND_MICROSECOND
SELECTSENSITIVE
SEPARATORSET
SHOWSMALLINT
SPATIALSPECIFIC
SQLSQLEXCEPTION
SQLSTATESQLWARNING
SQL_BIG_RESULTSQL_CALC_FOUND_ROWS
SQL_SMALL_RESULTSSL
STARTINGSTRAIGHT_JOIN
TABLETERMINATED
THENTINYBLOB
TINYINTTINYTEXT
TOTRAILING
TRIGGERTRUE
UNDOUNION
UNIQUEUNLOCK
UNSIGNEDUPDATE
USAGEUSE
USINGUTC_DATE
UTC_TIMEUTC_TIMESTAMP
VALUESVARBINARY
VARCHARVARCHARACTER
VARYINGWHEN
WHEREWHILE
WITHWRITE
X509XOR
YEAR_MONTHZEROFILL
标签:
声明:无特别说明,转载请标明本文来源!