{"id":359,"date":"2009-10-19T03:35:19","date_gmt":"2009-10-19T03:35:19","guid":{"rendered":"http:\/\/tw.newtonstudio.com\/?p=359"},"modified":"2010-05-19T04:06:14","modified_gmt":"2010-05-19T04:06:14","slug":"mysql-%e9%99%a4%e9%8c%af","status":"publish","type":"post","link":"http:\/\/tw.newtonstudio.com\/?p=359","title":{"rendered":"MYSQL \u9664\u932f"},"content":{"rendered":"<p>\u5f88\u591a\u6642\u5019\u6211\u5011\u5728\u4e0bSQL\u8a9e\u8a00\u6642\u51fa\u932f\u537b\u4e00\u76f4\u627e\u4e0d\u51fa\u539f\u56e0, \u5f88\u591a\u6642\u5019\u662f\u56e0\u70ba\u5728MYSQL\u5167\u7684COLUMN\u4f7f\u7528\u4e86reserved word \u800c\u9020\u6210\u7684. \u4ee5\u4e0b\u70baMYSQL \u7684reserved word, \u5982\u679c\u4f60\u5728\u547d\u540dtable.column\u6642\u5c31\u8981\u5118\u53ef\u80fd\u907f\u958b\u4f7f\u7528\u9019\u4e9b\u4fdd\u7559\u8b8a\u6578\u4e86.<\/p>\n<pre class=\"brush: sql;\">\r\nACCESSIBLE \tADD \tALL\r\nALTER \tANALYZE \tAND\r\nAS \tASC \tASENSITIVE\r\nBEFORE \tBETWEEN \tBIGINT\r\nBINARY \tBLOB \tBOTH\r\nBY \tCALL \tCASCADE\r\nCASE \tCHANGE \tCHAR\r\nCHARACTER \tCHECK \tCOLLATE\r\nCOLUMN \tCONDITION \tCONSTRAINT\r\nCONTINUE \tCONVERT \tCREATE\r\nCROSS \tCURRENT_DATE \tCURRENT_TIME\r\nCURRENT_TIMESTAMP \tCURRENT_USER \tCURSOR\r\nDATABASE \tDATABASES \tDAY_HOUR\r\nDAY_MICROSECOND \tDAY_MINUTE \tDAY_SECOND\r\nDEC \tDECIMAL \tDECLARE\r\nDEFAULT \tDELAYED \tDELETE\r\nDESC \tDESCRIBE \tDETERMINISTIC\r\nDISTINCT \tDISTINCTROW \tDIV\r\nDOUBLE \tDROP \tDUAL\r\nEACH \tELSE \tELSEIF\r\nENCLOSED \tESCAPED \tEXISTS\r\nEXIT \tEXPLAIN \tFALSE\r\nFETCH \tFLOAT \tFLOAT4\r\nFLOAT8 \tFOR \tFORCE\r\nFOREIGN \tFROM \tFULLTEXT\r\nGRANT \tGROUP \tHAVING\r\nHIGH_PRIORITY \tHOUR_MICROSECOND \tHOUR_MINUTE\r\nHOUR_SECOND \tIF \tIGNORE\r\nIN \tINDEX \tINFILE\r\nINNER \tINOUT \tINSENSITIVE\r\nINSERT \tINT \tINT1\r\nINT2 \tINT3 \tINT4\r\nINT8 \tINTEGER \tINTERVAL\r\nINTO \tIS \tITERATE\r\nJOIN \tKEY \tKEYS\r\nKILL \tLEADING \tLEAVE\r\nLEFT \tLIKE \tLIMIT\r\nLINEAR \tLINES \tLOAD\r\nLOCALTIME \tLOCALTIMESTAMP \tLOCK\r\nLONG \tLONGBLOB \tLONGTEXT\r\nLOOP \tLOW_PRIORITY \tMASTER_SSL_VERIFY_SERVER_CERT\r\nMATCH \tMEDIUMBLOB \tMEDIUMINT\r\nMEDIUMTEXT \tMIDDLEINT \tMINUTE_MICROSECOND\r\nMINUTE_SECOND \tMOD \tMODIFIES\r\nNATURAL \tNOT \tNO_WRITE_TO_BINLOG\r\nNULL \tNUMERIC \tON\r\nOPTIMIZE \tOPTION \tOPTIONALLY\r\nOR \tORDER \tOUT\r\nOUTER \tOUTFILE \tPRECISION\r\nPRIMARY \tPROCEDURE \tPURGE\r\nRANGE \tREAD \tREADS\r\nREAD_WRITE \tREAL \tREFERENCES\r\nREGEXP \tRELEASE \tRENAME\r\nREPEAT \tREPLACE \tREQUIRE\r\nRESTRICT \tRETURN \tREVOKE\r\nRIGHT \tRLIKE \tSCHEMA\r\nSCHEMAS \tSECOND_MICROSECOND \tSELECT\r\nSENSITIVE \tSEPARATOR \tSET\r\nSHOW \tSMALLINT \tSPATIAL\r\nSPECIFIC \tSQL \tSQLEXCEPTION\r\nSQLSTATE \tSQLWARNING \tSQL_BIG_RESULT\r\nSQL_CALC_FOUND_ROWS \tSQL_SMALL_RESULT \tSSL\r\nSTARTING \tSTRAIGHT_JOIN \tTABLE\r\nTERMINATED \tTHEN \tTINYBLOB\r\nTINYINT \tTINYTEXT \tTO\r\nTRAILING \tTRIGGER \tTRUE\r\nUNDO \tUNION \tUNIQUE\r\nUNLOCK \tUNSIGNED \tUPDATE\r\nUSAGE \tUSE \tUSING\r\nUTC_DATE \tUTC_TIME \tUTC_TIMESTAMP\r\nVALUES \tVARBINARY \tVARCHAR\r\nVARCHARACTER \tVARYING \tWHEN\r\nWHERE \tWHILE \tWITH\r\nWRITE \tXOR \tYEAR_MONTH\r\nZEROFILL \t  \t \r\n<\/pre>\n<p>The following are new reserved words in MySQL 5.1:<\/p>\n<pre class=\"brush: sql;\">\r\nACCESSIBLE \tLINEAR \tMASTER_SSL_VERIFY_SERVER_CERT\r\nRANGE \tREAD_ONLY \tREAD_WRITE\r\n<\/pre>\n<p>\u53c3\u8003\u8cc7\u6599: http:\/\/dev.mysql.com\/doc\/refman\/5.1\/en\/reserved-words.html<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u5f88\u591a\u6642\u5019\u6211\u5011\u5728\u4e0bSQL\u8a9e\u8a00\u6642\u51fa\u932f\u537b\u4e00\u76f4\u627e\u4e0d\u51fa\u539f\u56e0, \u5f88\u591a\u6642\u5019\u662f\u56e0\u70ba\u5728MYSQL\u5167\u7684COLUMN\u4f7f\u7528\u4e86reser [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[9,1],"tags":[121,122,124,123],"class_list":["post-359","post","type-post","status-publish","format-standard","hentry","category-mysql-","category-uncategorized","tag-mysql-reserved-variable","tag-mysql-reserved-words","tag-mysql"],"_links":{"self":[{"href":"http:\/\/tw.newtonstudio.com\/index.php?rest_route=\/wp\/v2\/posts\/359","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/tw.newtonstudio.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/tw.newtonstudio.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/tw.newtonstudio.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/tw.newtonstudio.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=359"}],"version-history":[{"count":2,"href":"http:\/\/tw.newtonstudio.com\/index.php?rest_route=\/wp\/v2\/posts\/359\/revisions"}],"predecessor-version":[{"id":453,"href":"http:\/\/tw.newtonstudio.com\/index.php?rest_route=\/wp\/v2\/posts\/359\/revisions\/453"}],"wp:attachment":[{"href":"http:\/\/tw.newtonstudio.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=359"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/tw.newtonstudio.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=359"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/tw.newtonstudio.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=359"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}