成都网站建设,10年成都网站设计公司-验收合格再付款网站建设分站|模板网站分站|网站维护分站
banner
网站首页>建站大学>技术支持 >Mysql关键字保留字列表Mysql字段名

Mysql关键字保留字列表Mysql字段名

添加时间:2019-03-30 22:51:52 编辑:成都网站建设 文章内容: 6895个字 阅读时间:约20分钟

啄木鸟建站关于Mysql保留字列表

尝试使用一个识别符,例如使用嵌入式MySQL 数据类型或函数名作为表名或列名,例如TIMESTAMP 或GROUP,会造成一个常见问题。允许你这样操作( 例如,ABS 可以作为一个列名) 。但是,默认情况下,在数调用中在函数名和后面的‘( ’字符之间不允许有空格。该要求使函数调用与列名引用不同。

Reserved Words in 

MySQL 5.6.23

  
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
NewReserved Words in MySQL 5.6  
GETIO_AFTER_GTIDSIO_BEFORE_GTIDS
MASTER_BINDONE_SHOTPARTITION
SQL_AFTER_GTIDSSQL_BEFORE_GTIDS 

MySQL permits some keywords to be used as unquoted identifiers because many people previously used them. Examples are those in the following list:

ACTION
BIT
DATE
ENUM
NO
TEXT
TIME
TIMESTAMP

上一篇:HTML代码规范下一篇:展示型和功能型网站建设内容包含哪些
如没有特殊注明,本文均来自于啄木鸟建站原创,转载请注明来自https://www.40b.cn/jishu/207.html

相关新闻

推荐新闻

成都网站建设案例

网站首页联系我们电话咨询短信咨询QQ咨询

啄木鸟工作室,为建站而生!网站建设And建站套餐