• SQL Error: 1064, SQLState: 42000


      这个错误是因为mysql有些关键字被我们用了,需要更改关键字成其他名字

      

    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

  • 相关阅读:
    STL逆序迭代器(reverse_iterator)
    STL容器之vector容器API(二)
    STL容器之vector容器巧用swap收缩空间
    STL容器之vector容器API(一)
    STL容器vector概念和注意事项(每次扩充都会重新开辟空间,释放原空间,即首元素地址会变一次)
    STL容器之string内存重定义
    STL容器之string与c_style类型转换
    STL容器之string插入和删除
    STL容器之string字串
    STL容器之string比较
  • 原文地址:https://www.cnblogs.com/nicknailo/p/9076287.html
Copyright © 2020-2023  润新知