02-14-2012, 09:09 PM
I have a problem when I want to import the file...
SQL-Befehl:
-- Items for NPC : Armor Tester
INSERT INTO t_shopitem( a_keeper_idx, a_item_idx )
VALUES -- Items for NPC : Magical Shopkeeper Coen
INSERT INTO t_shopitem( a_keeper_idx, a_item_idx )
VALUES ( 226, 781 ) , ( 226, 579 ) , ( 226, 580 ) , ( 226, 581 ) , ( 226, 582 ) , ( 226, 782 ) , ( 226, 583 ) , ( 226, 584 ) , ( 226, 585 ) , ( 226, 586 ) , ( 226, 783 ) , ( 226, 587 ) , ( 226, 588 ) , ( 226, 589 ) , ( 226, 590 ) , ( 226, 784 ) , ( 226, 591 ) , ( 226, 592 ) , ( 226, 593 ) , ( 226, 594 ) , ( 226, 785 ) , ( 226, 595 ) , ( 226, 596 ) , ( 226, 597 ) , ( 226, 598 ) , ( 226, 1121 ) , ( 226, 1122 ) , ( 226, 1123 ) , ( 226, 1124 ) , ( 226, 1125 ) , ( 226, 667 ) , ( 226, 668 ) , ( 226, 669 ) , ( 226, 677 ) , ( 226, 875 ) ;
MySQL meldet: Dokumentation
#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 t_shopitem (a_keeper_idx,a_item_idx) VALUES
(226,781),
(226,579), at line 5
pls help
(