mysql - 简单的语句：我的 SQL 语法有什么错误

Question

我找不到语法错误。spirit表格如下 ：

mysql> UPDATE spirit SET defend = 20, hp = 110, interval = 4 WHERE spirit_ID = 4;
ERROR 1064 (42000): 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 'interval = 4 WHERE spirit_ID = 4' at line 1

我很困惑，谢谢你的帮助。

标签： mysql

Answer 1

您可以尝试interval使用反引号（``）进行换行：

UPDATE spirit SET defend = 20, hp = 110, `interval` = 4 WHERE spirit_ID = 4;