Ich wollte bei meinem Server einen Shop mit Uppitems einbauen. Um nicht alle Uppitems manuell in die Db zu hämmern, habe ich mir eine Query gemacht. Jedoch bekomme ich wenn ich die Query ausführen will die Fehlermeldung
Code:
[Err] 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 'INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('17', '30008' at line 2
Code:
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('17', '30007', '2') INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('17', '30008', '2') INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('17', '30009', '2') INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('17', '30010', '2') INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('17', '30011', '2') INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('17', '30014', '2') INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('17', '30015', '2') INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('17', '30016', '2') INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('17', '30017', '2') INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('17', '30018', '2') INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('17', '30019', '2') INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('17', '30021', '2') INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('17', '30022', '2') INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('17', '30023', '2') INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('17', '30025', '2') INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('17', '30027', '2') INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('17', '30028', '2') INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('17', '30031', '2') INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('17', '30030', '2') INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('17', '30032', '2') INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('17', '30033', '2') INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('17', '30034', '2') INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('17', '30035', '2') INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('17', '30037', '2') INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('17', '30038', '2') INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('17', '30039', '2') INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('17', '30040', '2') INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('17', '30041', '2') INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('17', '30042', '2') INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('17', '30045', '2') INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('17', '30046', '2') INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('17', '30047', '2') INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('17', '30048', '2') INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('17', '30049', '2') INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('17', '30050', '2') INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('17', '30051', '2')