MySQL学习15_解决Mysql (1064) 错误: 1064 - You have an error in your SQL syntax

最新推荐文章于 2024-12-08 18:56:37 发布

转载最新推荐文章于 2024-12-08 18:56:37 发布 · 2.7k 阅读

4 ·

CC 4.0 BY-SA版权

原文链接：https://blog.youkuaiyun.com/destiny_strive/article/details/82698687

文章标签：

#MYSQL

MySQL 专栏收录该内容

19 篇文章

订阅专栏

在尝试向名为order的表插入数据时，遇到SQL语法错误。原因在于order是MySQL的保留字，解决方法包括使用反引号包裹表名或更改表名以避免使用保留字。

我在给数据库中的表添加数据的时候，

写的语句是：INSERT INTO order VALUES (2, '编号B')

表结构：

出现了错误：

INSERT INTO order VALUES (2, '编号B')
1064 - 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 'order VALUES (2, '编号B')' at line 1
时间: 0s

在检查了半天sql语句后发现没什么毛病，最后发现INSERT INTO order VALUES (2, '编号B')这段语句中用到了mysql的保留字order。

当时真没想到order居然也能是保留字。好坑啊。

解决办法如下：

1.表名order使用了mysql的关键字，把order用反引号号`括起来,就是键盘上Esc键下边的那个键。

2.修改order为不是mysql保留字的名称，也就是避免使用保留字。

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
————————————————
版权声明：本文为优快云博主「迷途的羔羊_」的原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接及本声明。
原文链接：https://blog.youkuaiyun.com/destiny_strive/article/details/82698687