You have an error in your SQL syntax;

最新推荐文章于 2025-09-10 14:30:23 发布

原创最新推荐文章于 2025-09-10 14:30:23 发布 · 721 阅读

2 ·

CC 4.0 BY-SA版权

文章标签：

#Mysql保留字 #数据库插入信息

博主在尝试插入数据到数据库时遇到了'You have an error in your SQL syntax;'的错误，经过排查，发现问题是由于表中字段名'describe'与MySQL保留字冲突导致。在检查SQL语句和Java程序无误后，最终找到问题根源并提醒读者注意SQL保留字可能带来的问题。

现在已经要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的保留字，看准了。

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