[Help]SQL Errorr

[Neth'zul]

Hey I put my SQL code in the SQL entry on the phpMyAdmin.

Error:

 #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 'INTO items (entry, class, subclass, field4, name1INSERT INTO items (entry, class' at line 1

My SQL I wanted to put:

INSERT INTO items (entry, class, subclass, field4, name1INSERT INTO items (entry, class, subclass, field4, name1INSERT INTO items (entry, class, subclass, field4, name1INSERT INTO items (entry, class, subclass, field4, name1INSERT INTO items (entry, class, subclass, field4, name1INSERT INTO items (entry, class, subclass, field4, name1INSERT INTO items (entry, class, subclass, field4, name1INSERT INTO items (entry, class, subclass, field4, name1INSERT INTO items (entry, class, subclass, field4, name1INSERT INTO items (entry, class, subclass, field4, name1INSERT INTO items (entry, class, subclass, field4, name1INSERT INTO items (entry, class, subclass, field4, name1INSERT INTO items (entry, class, subclass, field4, name1INSERT INTO items (entry, class, subclass, field4, name1INSERT INTO items (entry, class, subclass, field4, name1INSERT INTO items (entry, class, subclass, field4, name1INSERT INTO items (entry, class, subclass, field4, name1INSERT INTO items (entry, class, subclass, field4, name1INSERT INTO items (entry, class, subclass, field4, name1INSERT INTO items (entry, class, subclass, field4, name1INSERT INTO items (entry, class, subclass, field4, name1INSERT INTO items (entry, class, subclass, field4, name1INSERT INTO items (entry, class, subclass, field4, name1INSERT INTO items (entry, class, subclass, field4, name1INSERT INTO items (entry, class, subclass, field4, name1INSERT INTO items (entry, class, subclass, field4, name1INSERT INTO items (entry, class, subclass, field4, name1INSERT INTO items (entry, class, subclass, field4, name1INSERT INTO items (entry, class, subclass, field4, name1INSERT INTO items (entry, class, subclass, field4, name1INSERT INTO items (entry, class, subclass, field4, name1INSERT INTO items (entry, class, subclass, field4, name1INSERT INTO items (entry, class, subclass, field4, name1INSERT INTO items (entry, class, subclass, field4, name1INSERT INTO items (entry, class, subclass, field4, name1INSERT INTO items (entry, class, subclass, field4, name1INSERT INTO items (entry, class, subclass, field4, name1INSERT INTO items (entry, class, subclass, field4, name1INSERT INTO items (entry, class, subclass, field4, name1INSERT INTO items (entry, class, subclass, field4, name1INSERT INTO items (entry, class, subclass, field4, name1INSERT INTO items (entry, class, subclass, field4, name1INSERT INTO items (entry, class, subclass, field4, name1INSERT INTO items (entry, class, subclass, field4, name1INSERT INTO items (entry, class, subclass, field4, name1INSERT INTO items (entry, class, subclass, field4, name1INSERT INTO items (entry, class, subclass, field4, name1INSERT INTO items (entry, class, subclass, field4, name1INSERT INTO items (entry, class, subclass, field4, name1INSERT INTO items (entry, class, subclass, field4, name1INSERT INTO items (entry, class, subclass, field4, name1INSERT INTO items (entry, class, subclass, field4, name1INSERT INTO items (entry, class, subclass, field4, name1INSERT INTO items (entry, class, subclass, field4, name1INSERT INTO items (entry, class, subclass, field4, name1INSERT INTO items (entry, class, subclass, field4, name1INSERT INTO items (entry, class, subclass, field4, name1INSERT INTO items (entry, class, subclass, field4, name1INSERT INTO items (entry, class, subclass, field4, name1INSERT INTO items (entry, class, subclass, field4, name1INSERT INTO items (entry, class, subclass, field4, name1INSERT INTO items (entry, class, subclass, field4, name1INSERT INTO items (entry, class, subclass, field4, name1INSERT INTO items (entry, class, subclass, field4, name1

[TheSpidey]

That's just INSERT INTO items (entry, class, subclass, field4, name1 copypasted a dozen times, not an actual statement.

[Neth'zul]

O.o then WoW V is crazy! thanx TheSpidey! +rep

EDIT: Must wait...too much rep in 24.

EDIT 2: errr I tried it another way wehere I have the right code.....it says

INSERT INTO items (entry, class, subclass, field4, name1, name2, name3, name4, displayid, quality, flags, buyprice, sellprice, inventorytype, allowableclass, allowablerace, itemlevel, requiredlevel, RequiredSkill, RequiredSkillRank, RequiredSkillSubRank, RequiredPlayerRank1, RequiredPlayerRank2, RequiredFaction, RequiredFactionStanding, `Unique`, maxcount, ContainerSlots, stat_type1, stat_value1, stat_type2, stat_value2, stat_type3, stat_value3, stat_type4, stat_value4, stat_type5, stat_value5, stat_type6, stat_value6, stat_type7, stat_value7, stat_type8, stat_value8, stat_type9, stat_value9, stat_type10, stat_value10, dmg_min1, dmg_max1, dmg_type1, dmg_min2, dmg_max2, dmg_type2, dmg_min3, dmg_max3, dmg_type3, dmg_min4, dmg_max4, dmg_type4, dmg_min5, dmg_max5, dmg_type5, armor, holy_res, fire_res, nature_res, frost_res, shadow_res, arcane_res, delay, ammo_type, `range`, spellid_1, spelltrigger_1, spellcharges_1, spellcooldown_1, spellcategory_1, spellcategorycooldown_1, spellid_2, spelltrigger_2, spellcharges_2, spellcooldown_2, spellcategory_2, spellcategorycooldown_2, spellid_3, spelltrigger_3, spellcharges_3, spellcooldown_3, spellcategory_3, spellcategorycooldown_3, spellid_4, spelltrigger_4, spellcharges_4, spellcooldown_4, spellcategory_4, spellcategorycooldown_4, spellid_5, spelltrigger_5, spellcharges_5, spellcooldown_5, spellcategory_5, spellcategorycooldown_5, bonding, description, page_id, page_language, page_material, quest_id, lock_id, lock_material, sheathID, randomprop, unk203_1, block, itemset, MaxDurability, ZoneNameID, mapid, bagfamily, TotemCategory, socket_color_1, unk201_3, socket_color_2, unk201_5, socket_color_3, unk201_7, socket_bonus, GemProperties, ReqDisenchantSkill, unk2)
VALUES (10,4,1,-1,"Test","Test","Test","Test",22418,0,0,0000,0000,1,-1,-1,111,11,0,0,0,0,0,0,0,1,1,0, 0,0, 0,0, 0,0, 0,0, 0,0, 0,0, 1,1, 0,0, 0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,111,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"TEST",0,0,0,0,0,-1,0,0,0,11,0,1000,0,0,0,0,0,0,0,0,0,0,0,0,0,0);

[2dgreengiant]

INSERT INTO items (entry, class, subclass, field4, name1, name2, name3, name4, displayid, quality, flags, buyprice, sellprice, inventorytype, allowableclass, allowablerace, itemlevel, requiredlevel, RequiredSkill, RequiredSkillRank, RequiredSkillSubRank, RequiredPlayerRank1, RequiredPlayerRank2, RequiredFaction, RequiredFactionStanding, `Unique`, maxcount, ContainerSlots, stat_type1, stat_value1, stat_type2, stat_value2, stat_type3, stat_value3, stat_type4, stat_value4, stat_type5, stat_value5, stat_type6, stat_value6, stat_type7, stat_value7, stat_type8, stat_value8, stat_type9, stat_value9, stat_type10, stat_value10, dmg_min1, dmg_max1, dmg_type1, dmg_min2, dmg_max2, dmg_type2, dmg_min3, dmg_max3, dmg_type3, dmg_min4, dmg_max4, dmg_type4, dmg_min5, dmg_max5, dmg_type5, armor, holy_res, fire_res, nature_res, frost_res, shadow_res, arcane_res, delay, ammo_type, `range`, spellid_1, spelltrigger_1, spellcharges_1, spellcooldown_1, spellcategory_1, spellcategorycooldown_1, spellid_2, spelltrigger_2, spellcharges_2, spellcooldown_2, spellcategory_2, spellcategorycooldown_2, spellid_3, spelltrigger_3, spellcharges_3, spellcooldown_3, spellcategory_3, spellcategorycooldown_3, spellid_4, spelltrigger_4, spellcharges_4, spellcooldown_4, spellcategory_4, spellcategorycooldown_4, spellid_5, spelltrigger_5, spellcharges_5, spellcooldown_5, spellcategory_5, spellcategorycooldown_5, bonding, description, page_id, page_language, page_material, quest_id, lock_id, lock_material, sheathID, randomprop, unk203_1, block, itemset, MaxDurability, ZoneNameID, mapid, bagfamily, TotemCategory, socket_color_1, unk201_3, socket_color_2, unk201_5, socket_color_3, unk201_7, socket_bonus, GemProperties, ReqDisenchantSkill, unk2)
VALUES (10,4,1,-1,"Test","Test","Test","Test",22418,0,0,0000,0000,1,-1,-1,111,11,0,0,0,0,0,0,0,1,1,0, 0,0, 0,0, 0,0, 0,0, 0,0, 0,0, 1,1, 0,0, 0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,111,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"TEST",0,0,0,0,0,-1,0,0,0,11,0,1000,0,0,0,0,0,0,0,0,0,0,0,0,0,0);

Would be the correct code to execute into your database

[Neth'zul]

Thank you 2D , you have saved me once again. Can I have your MSN I have a question about the DBC Editor. +rep