Alguem poderia me infomar aonde se está o erro nessa sql?
SELECT * FROM `shop_item`;
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`) VALUES ('23', '50446')
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`) VALUES ('23', '50447')
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`) VALUES ('23', '50448')
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`) VALUES ('23', '50449')
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`) VALUES ('23', '50450')
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`) VALUES ('24', '50461')
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`) VALUES ('24', '50462')
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`) VALUES ('24', '50463')
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`) VALUES ('24', '50464')
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`) VALUES ('24', '50465')
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`) VALUES ('24', '50466')
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`) VALUES ('25', '50476')
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`) VALUES ('25', '50477')
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`) VALUES ('25', '50478')
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`) VALUES ('25', '50479')
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`) VALUES ('25', '50480')
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`) VALUES ('25', '50481')
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`) VALUES ('26', '50491')
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`) VALUES ('26', '50492')
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`) VALUES ('26', '50493')
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`) VALUES ('26', '50494')
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`) VALUES ('26', '50495')
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`) VALUES ('26', '50496')
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`) VALUES ('27', '50506')
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`) VALUES ('27', '50507')
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`) VALUES ('27', '50508')
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`) VALUES ('27', '50509')
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`) VALUES ('27', '50510')
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`) VALUES ('27', '50511')
me retorna a seguinte mensagem:
[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`) VALUES ('23', '50447')
Alguem poderia me infomar aonde se está o erro nessa sql?
me retorna a seguinte mensagem:
Share this post
Link to post
Share on other sites