今天这个问题纠结好久,找到问题原因如下:
在MySQL 中,下表中的字显式被保留。其中大多数字进制被标准SQL 用作列名和/ 或表名( 例如,GROUP ) 。少数被保留了,因为MySQL 需要它们,( 目前) 使用yacc 解析程序。保留字 被引起来后可以用作识别符。
你不小心使用了下面的关键字 那么就会报这个错误
“SQL Error: 1064, SQLState: 42000错误”
ADD | ALL | ALTER |
ANALYZE | AND | AS |
ASC | ASENSITIVE | BEFORE |
BETWEEN | BIGINT | BINARY |
BLOB | BOTH | BY |
CALL | CASCADE | CASE |
CHANGE | CHAR | CHARACTER |
CHECK | COLLATE | COLUMN |
CONDITION | CONNECTION | CONSTRAINT |
CONTINUE | CONVERT | CREATE |
CROSS | CURRENT_DATE | CURRENT_TIME |
CURRENT_TIMESTAMP | CURRENT_USER | CURSOR |
DATABASE | DATABASES | DAY_HOUR |
DAY_MICROSECOND | DAY_MINUTE | DAY_SECOND |
DEC | DECIMAL | DECLARE |
DEFAULT | DELAYED | DELETE |
DESC | DESCRIBE | DETERMINISTIC |
DISTINCT | DISTINCTROW | DIV |
DOUBLE | DROP | DUAL |
EACH | ELSE | ELSEIF |
ENCLOSED | ESCAPED | EXISTS |
EXIT | EXPLAIN | FALSE |
FETCH | FLOAT | FLOAT4 |
FLOAT8 | FOR | FORCE |
FOREIGN | FROM | FULLTEXT |
GOTO | GRANT | GROUP |
HAVING | HIGH_PRIORITY | HOUR_MICROSECOND |
HOUR_MINUTE | HOUR_SECOND | IF |
IGNORE | IN | INDEX |
INFILE | INNER | INOUT |
INSENSITIVE | INSERT | INT |
INT1 | INT2 | INT3 |
INT4 | INT8 | INTEGER |
INTERVAL | INTO | IS |
ITERATE | JOIN | KEY |
KEYS | KILL | LABEL |
LEADING | LEAVE | LEFT |
LIKE | LIMIT | LINEAR |
LINES | LOAD | LOCALTIME |
LOCALTIMESTAMP | LOCK | LONG |
LONGBLOB | LONGTEXT | LOOP |
LOW_PRIORITY | MATCH | MEDIUMBLOB |
MEDIUMINT | MEDIUMTEXT | MIDDLEINT |
MINUTE_MICROSECOND | MINUTE_SECOND | MOD |
MODIFIES | NATURAL | NOT |
NO_WRITE_TO_BINLOG | NULL | NUMERIC |
ON | OPTIMIZE | OPTION |
OPTIONALLY | OR | ORDER |
OUT | OUTER | OUTFILE |
PRECISION | PRIMARY | PROCEDURE |
PURGE | RAID0 | RANGE |
READ | READS | REAL |
REFERENCES | REGEXP | RELEASE |
RENAME | REPEAT | REPLACE |
REQUIRE | RESTRICT | RETURN |
REVOKE | RIGHT | RLIKE |
SCHEMA | SCHEMAS | SECOND_MICROSECOND |
SELECT | SENSITIVE | SEPARATOR |
SET | SHOW | SMALLINT |
SPATIAL | SPECIFIC | SQL |
SQLEXCEPTION | SQLSTATE | SQLWARNING |
SQL_BIG_RESULT | SQL_CALC_FOUND_ROWS | SQL_SMALL_RESULT |
SSL | STARTING | STRAIGHT_JOIN |
TABLE | TERMINATED | THEN |
TINYBLOB | TINYINT | TINYTEXT |
TO | TRAILING | TRIGGER |
TRUE | UNDO | UNION |
UNIQUE | UNLOCK | UNSIGNED |
UPDATE | USAGE | USE |
USING | UTC_DATE | UTC_TIME |
UTC_TIMESTAMP | VALUES | VARBINARY |
VARCHAR | VARCHARACTER | VARYING |
WHEN | WHERE | WHILE |
WITH | WRITE | X509 |
XOR | YEAR_MONTH | ZEROFILL |
相关推荐
奈达代表作书名Toward a Science of Translating译成"翻译科学探索"引起译论界高度的关注和激烈争论。译文"翻译科学探索"中的两个词——"翻译科学"和"探索",都值得很好的商榷。Toward a Science of Translating的...
全球统一商品编码(Universal Product Code,简称UPC)是一种在零售点用来识别产品的条码系统,广泛应用于商品销售过程中。尽管UPC条码包含大量信息,但为了提高供应链的效率,行业正逐渐转向使用射频识别(RFID)...
SDL Trados Studio 是一款专业的翻译记忆和术语管理系统,适合翻译人员和项目经理使用,特别是在需要翻译和审校文档的工作中。SDL Trados 提供了快速开始的指导,帮助用户通过其软件界面进行翻译工作,并对翻译文档...
Data Validation Code with DDV_ Using ClassWizard Performing Cross-Edits About Live Edits Using Common Dialogs File Save and Save As File Open Print Font Browser Color Chooser Summary ...
to write code that can compile on different hardware architectures and optimize automatically complex mathematical objective functions. Chapter 2, Classifying Handwritten Digits with a Feedforward ...
【标题】"code for code.zip_practice" 指的是一个包含了编程实践代码的压缩文件,主要用于Fortran语言的学习和操练。这个标题暗示了文件的内容主要是为了帮助用户熟悉和提高在Fortran编程中的技能。 【描述】...
- All published methods in well commented ASM code with references to strings, imported function calls, classes methods calls, components in the unit, Try-Except and Try-Finally blocks. By default ...
Translating Applications Chapter 19. Look and Feel Customization Using Qt Style Sheets Subclassing QStyle Chapter 20. 3D Graphics Drawing Using OpenGL Combining OpenGL and QPainter Doing...
Each strategy has its own advantages and challenges when it comes to translating UML models into C code. #### Functional C UML Profile The functional C UML profile is a specialized subset of UML ...
### iOS9 Programming Fundamentals with Swift (Swift.Xcode.and.Cocoa.Basics) #### Preface and Introduction to Swift On June 2, 2014, Apple made a groundbreaking announcement at its Worldwide ...
First of all I would like to thank Ralf Gerstner from Springer for this and for his helpful suggestions for improvement, as well as Annika Brun for translating most of the text, Colin Marsh for copy ...
**Exception Translation**: By translating MyBatis-specific exceptions to Spring's DataAccessException hierarchy, MyBatis-Spring ensures that your application's error handling remains consistent with ...
标题中的"code code.zip_Fortran_UMAT_zip"表明这是一个与Fortran编程语言和UMAT(User-Defined Material)相关的代码压缩包。UMAT是有限元分析软件ABAQUS中的一个子程序,允许用户自定义材料行为。下面将详细探讨...
The biggest problem with the Microsoft default code generator is that the generated constructor is protected, which means that it can’t be used to construct strongly-typed resources in Visual Studio...
- All published methods in well commented ASM code with references to strings, imported function calls, classes methods calls, components in the unit, Try-Except and Try-Finally blocks. (By default ...
「数据安全」securing the budget you need translating technology costs to business impact - 数据库安全 渗透测试 攻防实训 NGFW 云安全 网络安全
Chapter 7: Writing Safer Code with Availability and Error Handling Chapter 8: Working with XML and JSON Data Chapter 9: Custom Subscripting Chapter 10: Using Optional Types Chapter 11: Working with ...