`

Translating SQLException with SQL state '42000', error code '1064'

 
阅读更多

今天这个问题纠结好久,找到问题原因如下:

 

在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译成"翻译科学探索"引起译论界高度的关注和激烈争论。译文"翻译科学探索"中的两个词——"翻译科学"和"探索",都值得很好的商榷。Toward a Science of Translating的...

    Translating UPC to EPC

    全球统一商品编码(Universal Product Code,简称UPC)是一种在零售点用来识别产品的条码系统,广泛应用于商品销售过程中。尽管UPC条码包含大量信息,但为了提高供应链的效率,行业正逐渐转向使用射频识别(RFID)...

    Trados Translating And Reviewing Documents

    SDL Trados Studio 是一款专业的翻译记忆和术语管理系统,适合翻译人员和项目经理使用,特别是在需要翻译和审校文档的工作中。SDL Trados 提供了快速开始的指导,帮助用户通过其软件界面进行翻译工作,并对翻译文档...

    Professional.MFC.with.VC6

    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 ...

    源码Deep Learning with Theano

    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

    【标题】"code for code.zip_practice" 指的是一个包含了编程实践代码的压缩文件,主要用于Fortran语言的学习和操练。这个标题暗示了文件的内容主要是为了帮助用户熟悉和提高在Fortran编程中的技能。 【描述】...

    Dede(反汇编Delphi)

    - 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 ...

    Prentice.Hall.C++.GUI.Programming.with.Qt.4.2nd.Edition.2008.chm

    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...

    UML for the C programming language

    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)

    ### 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 ...

    Data Visualisation with R_100 Examples-Springer(2017).pdf

    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 ...

    Spring和Mybatis整合英文文档翻译.pdf

    **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

    标题中的"code code.zip_Fortran_UMAT_zip"表明这是一个与Fortran编程语言和UMAT(User-Defined Material)相关的代码压缩包。UMAT是有限元分析软件ABAQUS中的一个子程序,允许用户自定义材料行为。下面将详细探讨...

    Visual_Studio_Package.vsix

    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...

    delphi反编译工具 dede3.99

    - 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 cos

    「数据安全」securing the budget you need translating technology costs to business impact - 数据库安全 渗透测试 攻防实训 NGFW 云安全 网络安全

    Packt.Swift.Developing.iOS.Applications.2016

    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 ...

Global site tag (gtag.js) - Google Analytics