因mysql表名与mysql关键字冲突导致的com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException
来源:互联网 发布:悉知的意思 编辑:程序博客网 时间:2024/05/23 00:26
最近在使用activiti实战中的代码,将ORM框架由hibernate换成了mybatis,在使用第7章的请假实例时,插入mysql数据库出现了com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException错误,找了半天最终发现使用了mysql的预留关键字leave,修改leave表格名字后一切正常,真是一次崎岖的bug之旅,故记录下来,希望帮到遇到相同问题的人!
这里顺便贴下mysql的常用关键字:
ADDALLALTERANALYZEANDASASCASENSITIVEBEFOREBETWEENBIGINTBINARYBLOBBOTHBYCALLCASCADECASECHANGECHARCHARACTERCHECKCOLLATECOLUMNCONDITIONCONNECTIONCONSTRAINTCONTINUECONVERTCREATECROSSCURRENT_DATECURRENT_TIMECURRENT_TIMESTAMPCURRENT_USERCURSORDATABASEDATABASESDAY_HOURDAY_MICROSECONDDAY_MINUTEDAY_SECONDDECDECIMALDECLAREDEFAULTDELAYEDDELETEDESCDESCRIBEDETERMINISTICDISTINCTDISTINCTROWDIVDOUBLEDROPDUALEACHELSEELSEIFENCLOSEDESCAPEDEXISTSEXITEXPLAINFALSEFETCHFLOATFLOAT4FLOAT8FORFORCEFOREIGNFROMFULLTEXTGOTOGRANTGROUPHAVINGHIGH_PRIORITYHOUR_MICROSECONDHOUR_MINUTEHOUR_SECONDIFIGNOREININDEXINFILEINNERINOUTINSENSITIVEINSERTINTINT1INT2INT3INT4INT8INTEGERINTERVALINTOISITERATEJOINKEYKEYSKILLLABELLEADINGLEAVELEFTLIKELIMITLINEARLINESLOADLOCALTIMELOCALTIMESTAMPLOCKLONGLONGBLOBLONGTEXTLOOPLOW_PRIORITYMATCHMEDIUMBLOBMEDIUMINTMEDIUMTEXTMIDDLEINTMINUTE_MICROSECONDMINUTE_SECONDMODMODIFIESNATURALNOTNO_WRITE_TO_BINLOGNULLNUMERICONOPTIMIZEOPTIONOPTIONALLYORORDEROUTOUTEROUTFILEPRECISIONPRIMARYPROCEDUREPURGERAID0RANGEREADREADSREALREFERENCESREGEXPRELEASERENAMEREPEATREPLACEREQUIRERESTRICTRETURNREVOKERIGHTRLIKESCHEMASCHEMASSECOND_MICROSECONDSELECTSENSITIVESEPARATORSETSHOWSMALLINTSPATIALSPECIFICSQLSQLEXCEPTIONSQLSTATESQLWARNINGSQL_BIG_RESULTSQL_CALC_FOUND_ROWSSQL_SMALL_RESULTSSLSTARTINGSTRAIGHT_JOINTABLETERMINATEDTHENTINYBLOBTINYINTTINYTEXTTOTRAILINGTRIGGERTRUEUNDOUNIONUNIQUEUNLOCKUNSIGNEDUPDATEUSAGEUSEUSINGUTC_DATEUTC_TIMEUTC_TIMESTAMPVALUESVARBINARYVARCHARVARCHARACTERVARYINGWHENWHEREWHILEWITHWRITEX509XORYEAR_MONTHZEROFILL
阅读全文
0 0
- 因mysql表名与mysql关键字冲突导致的com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException
- com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException
- 异常:com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException
- com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException
- com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'password' in
- com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column
- com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException报错解决方法
- com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown database 'user'
- com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException解决方式
- com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown database 'smvch'
- Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 解决方案
- com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException异常问题
- com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown database 'user'
- com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException异常原因解析
- com.mysql.jdbc.exceptions.MySQLSyntaxErrorException:
- com.mysql.jdbc.exceptions.MySQLSyntaxErrorException
- Hibernate com.mysql.jdbc.exceptions.MySQLSyntaxErrorException MYSQL
- MySQL 插入图片时出现com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:
- 【Django】使用ImageField
- ORACLE 03 用户,方案的创建与管理
- (OK) Android-x86-7.1.1/ kernel 4.4.62
- oracle数据库CPU特别高的解决方法
- PHP 常量
- 因mysql表名与mysql关键字冲突导致的com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException
- Mybatis出错:Error instantiating class xxx with invalid types () or values ()
- LeetCode: 344. Reverse String
- 微信小程序如何介入新零售,打通营销闭环?
- moveToThread()
- ORB_SLAM ORBextractor 特征点提取 opencv源码学习
- 机器学习笔记之无监督学习
- 数据依赖性含义
- C#中使用DirectSound录音