check the manual that corresponds to your MySQL server version for the right syntax错误
来源:互联网 发布:淘宝有哪些家具店不错 编辑:程序博客网 时间:2024/05/16 09:47
昨天晚上,用Hibernate做多对多映射,然后测试,结果直接报check the manual that corresponds to your MySQL server version for the right syntax to use near 'Order (moneys, orderNumber) values (0.0, 'A001')'。晚上检查半天都没检查出来,后来就和女票出去玩了。
早上再次运行还是报同样的错误,然后突然脑子一想会不会是Order表,出现关键字吧,果不其然,把表名从order改为t_order就运行成功了。。。。。
拓展一下,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阅读全文
1 0
- MySQL check the manual that corresponds to your MySQL server version for the right syntax错误
- MySQL check the manual that corresponds to your MySQL server version for the right syntax错误
- MySQL check the manual that corresponds to your MySQL server version for the right syntax错误
- MySQL check the manual that corresponds to your MySQL server version for the right syntax错误
- MySQL check the manual that corresponds to your MySQL server version for the right syntax错误
- MySQL check the manual that corresponds to your MySQL server version for the right syntax错误
- MySQL check the manual that corresponds to your MySQL server version for the right syntax错误
- MySQL check the manual that corresponds to your MySQL server version for the right syntax错误
- MySQL check the manual that corresponds to your MySQL server version for the right syntax错误
- check the manual that corresponds to your MySQL server version for the right syntax错误
- check the manual that corresponds to your MySQL server version for the right syntax to use
- check the manual that corresponds to your MySQL server version for the right syntax to
- MySQL:check the manual that corresponds to your MySQL server version for the right syntax
- MySQL check the manual that corresponds to your MySQL server version for the right syntax
- 01-check the manual that corresponds to your MySQL server version for the right syntax
- check the manual that corresponds to your MySQL server version for the right syntax
- check the manual that corresponds to your MySQL server version for the right syntax
- check the manual that corresponds to your MySQL server version for the right syntax的解决方法
- codis3.2安装报错dashboard.go:369: [PANIC] call rpc create-proxy to dashboard 127.0.0.1:18080 failed的处理
- 文件缓存tmpfs简单使用
- centos6.5环境wget报错Unable to establish SSL connection
- 每天五分钟linux(11)-nl
- zabbix3.0.4使用percona-monitoring-plugins插件来监控mysql5.6的详细实现过程
- check the manual that corresponds to your MySQL server version for the right syntax错误
- ssdb主从及双主模型配置和简单管理
- 通过codis3.2实现redis3.2.8集群的管理
- percona-xtrabackup工具实现mysql5.6.34的主从同步复制
- lvs+keepalived实现负载均衡
- OpenStack实践系列①openstack简介及基础环境部署
- OpenStack实践系列②认证服务Keystone
- OpenStack实践系列③镜像服务Glance
- OpenStack实践系列④计算服务Nova