[Help] SQL Query

[Sabens]

Hey guys. Just need some help with this sql query. When I try to execute it, I get a syntax error.

Here is the query:

INSERT INTO creature_names (entry, name, subname, info_str, Flags1, type, family, rank, male_displayid, female_displayid, male_displayid2, female_displayid2, civilian, leader) VALUES ('999990','Scarlet Guardsman','','','0','7','0','1','10512','0','0','0','0','0')

INSERT INTO creature_proto (entry, minlevel, maxlevel, faction, minhealth, maxhealth, mana, scale, npcflags, attacktime, mindamage, maxdamage, rangedattacktime, rangedmindamage, rangedmaxdamage, mountdisplayid, equipmodel1, equipmodel2, equipmodel3, respawntime, armor, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, combat_reach, auras, boss, money, invisibility_type, death_state, walk_speed, run_speed, fly_speed) VALUES ('999990','71','72','21','36660','36670','0','0','3100','614','858','0','0','0','0','41929','47250','0','500000','7000','1','1','1','1','1','1','1','0','0','92500','0','0','2.5','8','14')

Any help is greatly appreciated.

[Reflection]

INSERT INTO creature_names (entry, name, subname, info_str, Flags1, type, family, rank, male_displayid, female_displayid, male_displayid2, female_displayid2, civilian, leader) VALUES ('999990','Scarlet Guardsman','','','0','7','0','1','10512','0','0','0','0','0');

INSERT INTO creature_proto (entry, minlevel, maxlevel, faction, minhealth, maxhealth, mana, scale, npcflags, attacktime, mindamage, maxdamage, rangedattacktime, rangedmindamage, rangedmaxdamage, mountdisplayid, equipmodel1, equipmodel2, equipmodel3, respawntime, armor, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, combat_reach, auras, boss, money, invisibility_type, death_state, walk_speed, run_speed, fly_speed) VALUES ('999990','71','72','21','36660','36670','0','0','3100','614','858','0','0','0','0','41929','47250','0','500000','7000','1','1','1','1','1','1','1','0','0','92500','0','0','2.5','8','14');

Should work.

[Sabens]

Hmm, still getting an error saying:

"[Err] 1136 - Column count doesn't match value count at row 1"

[Reflection]

Your database is either out of date or too new for the query, you should update your database.

[Sabens]

Alright, thanks for the help.