You have an error in your SQL syntax;
来源:互联网 发布:龙门县平陵镇网络问政 编辑:程序博客网 时间:2024/06/04 23:19
现在已经要11点了,我还是激动的不要不要的,要写下这一篇博客。毕竟这个问题困扰了我一天,整整一天啊。很简单的一个操作,数据插入到表中。
sql语句写好了,Java程序也写好了,然后开始测试。好嘛,报错了。如下:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'describe,photo,time) values('?????‰','201591110412','178','é—¨??—','??§?€?','203' at line 1
然后我就百度了一下错误,发现基本都是说sql语句有错误。看到这大家可能会自然地去检查sql语句。有没有多了或者少了逗号呀。插入顺序表中的顺序一样 嘛
。可是我没有发现我的sql语句有错。毕竟语句很简单。 我就开始怀疑java程序有问题。然后就开始看java语句。把Connection PreparedStatement 常用方法又复习了一遍。哈哈。 依然是没有解决。 突然想起了sql的保留字。没错,就是这。 表中有个字段叫describe.。。 就是他。困扰了就么久。 希望大家引以为戒。
这个错误虽然很low,但是百度上找到的基本没有提到保留字问题的。 可能这种巧合很小吧。既然让我碰上了,那就总结一下咯。
下面是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
- You have an error in your SQL syntax
- MySql JDBC:You have an error in your SQL syntax;
- You have an error in your SQL syntax的解决方法
- 抛出 异常 You have an error in your SQL syntax...
- You have an error in your SQL syntax;解决方法
- 1064 - You have an error in your SQL syntax问题解决
- You have an error in your SQL syntax;
- You have an error in your SQL syntax
- You have an error in your SQL syntax;
- You have an error in your SQL syntax;
- You have an error in your SQL syntax
- You have an error in your SQL syntax;
- 异常之You have an error in your SQL syntax
- Failed - Error on Table mi_oauth - 1064 - You have an error in your SQL syntax;
- Error 1064(42000):you have an error in your sql syntax;一个简单的原因
- 完美解决 ERROR 1064 (42000): You have an error in your SQL syntax ... near …
- ERROR 1064 (42000): You have an error in your SQL syntax
- phpmyadmin建表出错 #1064 - You have an error in your SQL syntax;
- [转载]Python爬取豆瓣影评并生成词云图代码
- SuperWebview开发指南1
- 关于维度建模中的事实
- npm升级到最新版本
- 矩形相似度匹配 , 两条件决定因素的相似度匹配
- You have an error in your SQL syntax;
- HTML5学习笔记 —— JavaScript基础知识
- Jenkins之邮件通知
- 我的C#学习笔记1 -- 打印到控制台
- Spring Boot 实现 HTTPS
- javafx cell在初始化过程中如何获得其他列的值
- 17AHU排位赛2 A题(最小生成树、LCA维护树上路径)
- tensorflow运维(2):tensorboard:No scalar data was found,没有发现常量数据
- 为什么扫描枪只能扫入数字但是扫不进字母