MySQL关键字

       使用mybatis框架用到selectByExample时发现sql报错，发现原来数据库有张表字段名为maxValue，与数据库关键字冲突了，另一张表有year,month,date这三个关键字却没影响，网上查了查关键字记录下来以便下次查询。

           如果字段不能改，可以在代码改成自定义sql，然后在sql语句中将与关键字重名的字段用`字段名`替代，如：`maxValue`。

Reserved Words in 

MySQL 5.6.23

  ACCESSIBLEADDALLALTERANALYZEANDASASCASENSITIVEBEFOREBETWEENBIGINTBINARYBLOBBOTHBYCALLCASCADECASECHANGECHARCHARACTERCHECKCOLLATECOLUMNCONDITIONCONSTRAINTCONTINUECONVERTCREATECROSSCURRENT_DATECURRENT_TIMECURRENT_TIMESTAMPCURRENT_USERCURSORDATABASEDATABASESDAY_HOURDAY_MICROSECONDDAY_MINUTEDAY_SECONDDECDECIMALDECLAREDEFAULTDELAYEDDELETEDESCDESCRIBEDETERMINISTICDISTINCTDISTINCTROWDIVDOUBLEDROPDUALEACHELSEELSEIFENCLOSEDESCAPEDEXISTSEXITEXPLAINFALSEFETCHFLOATFLOAT4FLOAT8FORFORCEFOREIGNFROMFULLTEXTGETGRANTGROUPHAVINGHIGH_PRIORITYHOUR_MICROSECONDHOUR_MINUTEHOUR_SECONDIFIGNOREININDEXINFILEINNERINOUTINSENSITIVEINSERTINTINT1INT2INT3INT4INT8INTEGERINTERVALINTOIO_AFTER_GTIDSIO_BEFORE_GTIDSISITERATEJOINKEYKEYSKILLLEADINGLEAVELEFTLIKELIMITLINEARLINESLOADLOCALTIMELOCALTIMESTAMPLOCKLONGLONGBLOBLONGTEXTLOOPLOW_PRIORITYMASTER_BINDMASTER_SSL_VERIFY_SERVER_CERTMATCHMAXVALUEMEDIUMBLOBMEDIUMINTMEDIUMTEXTMIDDLEINTMINUTE_MICROSECONDMINUTE_SECONDMODMODIFIESNATURALNOTNO_WRITE_TO_BINLOGNULLNUMERICONOPTIMIZEOPTIONOPTIONALLYORORDEROUTOUTEROUTFILEPARTITIONPRECISIONPRIMARYPROCEDUREPURGERANGEREADREADSREAD_WRITEREALREFERENCESREGEXPRELEASERENAMEREPEATREPLACEREQUIRERESIGNALRESTRICTRETURNREVOKERIGHTRLIKESCHEMASCHEMASSECOND_MICROSECONDSELECTSENSITIVESEPARATORSETSHOWSIGNALSMALLINTSPATIALSPECIFICSQLSQLEXCEPTIONSQLSTATESQLWARNINGSQL_BIG_RESULTSQL_CALC_FOUND_ROWSSQL_SMALL_RESULTSSLSTARTINGSTRAIGHT_JOINTABLETERMINATEDTHENTINYBLOBTINYINTTINYTEXTTOTRAILINGTRIGGERTRUEUNDOUNIONUNIQUEUNLOCKUNSIGNEDUPDATEUSAGEUSEUSINGUTC_DATEUTC_TIMEUTC_TIMESTAMPVALUESVARBINARYVARCHARVARCHARACTERVARYINGWHENWHEREWHILEWITHWRITEXORYEAR_MONTHZEROFILL

 

 

NewReserved Words in MySQL 5.6  GETIO_AFTER_GTIDSIO_BEFORE_GTIDSMASTER_BINDONE_SHOTPARTITIONSQL_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