mysql - 错误 1064 (42000) MySQL。 (没有缩进，一切都用反引号转义

Question

我刚收到这个错误:

ERROR 1064 (42000) at line 1: 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 'INSERT INTO aq_db. aq_shops (ShopId, ItemCategory, ShopBitmask, ItemId' at line 3

另一个问题的答案告诉我要使用反引号——我已经这样做了。

这就是我想要运行的。

INSERT INTO aq_db. `aq_shops` (`ShopId`, `ItemCategory`, `ShopBitmask`, `ItemId`, `Buyable`)
VALUES (133, '', '', '', '')
INSERT INTO aq_db. `aq_shops` (`ShopId`, `ItemCategory`, `ShopBitmask`, `ItemId`, `Buyable`)
VALUES (133, 'weapon', 6, 4839, 1)
INSERT INTO aq_db. `aq_shops` (`ShopId`, `ItemCategory`, `ShopBitmask`, `ItemId`, `Buyable`)
VALUES (133, 'weapon', 1, 4832, 1)
INSERT INTO aq_db. `aq_shops` (`ShopId`, `ItemCategory`, `ShopBitmask`, `ItemId`, `Buyable`)
VALUES (133, 'weapon', 6, 4840, 1)
INSERT INTO aq_db. `aq_shops` (`ShopId`, `ItemCategory`, `ShopBitmask`, `ItemId`, `Buyable`)
VALUES (133, 'weapon', 1, 4833, 1)
INSERT INTO aq_db. `aq_shops` (`ShopId`, `ItemCategory`, `ShopBitmask`, `ItemId`, `Buyable`)
VALUES (133, 'weapon', 6, 4841, 1)
INSERT INTO aq_db. `aq_shops` (`ShopId`, `ItemCategory`, `ShopBitmask`, `ItemId`, `Buyable`)
VALUES (133, 'armor', 6, 1276, 1)
INSERT INTO aq_db. `aq_shops` (`ShopId`, `ItemCategory`, `ShopBitmask`, `ItemId`, `Buyable`)
VALUES (133, 'armor', 1, 1271, 1)
INSERT INTO aq_db. `aq_shops` (`ShopId`, `ItemCategory`, `ShopBitmask`, `ItemId`, `Buyable`)
VALUES (133, 'armor', 6, 1277, 1)
INSERT INTO aq_db. `aq_shops` (`ShopId`, `ItemCategory`, `ShopBitmask`, `ItemId`, `Buyable`)
VALUES (133, 'armor', 1, 1272, 1)
INSERT INTO aq_db. `aq_shops` (`ShopId`, `ItemCategory`, `ShopBitmask`, `ItemId`, `Buyable`)
VALUES (133, 'armor', 6, 1278, 1)
INSERT INTO aq_db. `aq_shops` (`ShopId`, `ItemCategory`, `ShopBitmask`, `ItemId`, `Buyable`)
VALUES (133, 'armor', 2, 212, 1)
INSERT INTO aq_db. `aq_shops` (`ShopId`, `ItemCategory`, `ShopBitmask`, `ItemId`, `Buyable`)
VALUES (133, 'shield', 6, 825, 1)
INSERT INTO aq_db. `aq_shops` (`ShopId`, `ItemCategory`, `ShopBitmask`, `ItemId`, `Buyable`)
VALUES (133, 'shield', 1, 820, 1)
INSERT INTO aq_db. `aq_shops` (`ShopId`, `ItemCategory`, `ShopBitmask`, `ItemId`, `Buyable`)
VALUES (133, 'shield', 6, 826, 1)
INSERT INTO aq_db. `aq_shops` (`ShopId`, `ItemCategory`, `ShopBitmask`, `ItemId`, `Buyable`)
VALUES (133, 'shield', 1, 821, 1)
INSERT INTO aq_db. `aq_shops` (`ShopId`, `ItemCategory`, `ShopBitmask`, `ItemId`, `Buyable`)
VALUES (133, 'shield', 6, 827, 1)
INSERT INTO aq_db. `aq_shops` (`ShopId`, `ItemCategory`, `ShopBitmask`, `ItemId`, `Buyable`)
VALUES (133, 'pet', 6, 1624, 1)
INSERT INTO aq_db. `aq_shops` (`ShopId`, `ItemCategory`, `ShopBitmask`, `ItemId`, `Buyable`)
VALUES (133, 'pet', 1, 1623, 1)
INSERT INTO aq_db. `aq_shops` (`ShopId`, `ItemCategory`, `ShopBitmask`, `ItemId`, `Buyable`)
VALUES (133, 'pet', 6, 1625, 1)
INSERT INTO aq_db. `aq_shops` (`ShopId`, `ItemCategory`, `ShopBitmask`, `ItemId`, `Buyable`)
VALUES (133, 'pet', 1, 258, 1)
INSERT INTO aq_db. `aq_shops` (`ShopId`, `ItemCategory`, `ShopBitmask`, `ItemId`, `Buyable`)
VALUES (133, 'pet', 6, 1626, 1)
INSERT INTO aq_db. `aq_shops` (`ShopId`, `ItemCategory`, `ShopBitmask`, `ItemId`, `Buyable`)
VALUES (133, 'item', 6, 333, 1)
INSERT INTO aq_db. `aq_shops` (`ShopId`, `ItemCategory`, `ShopBitmask`, `ItemId`, `Buyable`)
VALUES (133, 'item', 6, 334, 1)

为什么会出现错误？我逃脱了一切。

Answer 1

您需要用 ; 分隔 insert 语句:

INSERT INTO aq_db. `aq_shops` (`ShopId`, `ItemCategory`, `ShopBitmask`, `ItemId`, `Buyable`)
VALUES (133, '', '', '', ''); -- Note the ;
INSERT INTO aq_db. `aq_shops` (`ShopId`, `ItemCategory`, `ShopBitmask`, `ItemId`, `Buyable`)
VALUES (133, 'weapon', 6, 4839, 1);