[HELP]SQL.

[ShuN^]

I want to execute a batch file into the navicat.The .sql file contains this:

INSERT INTO `custom_armor` VALUES ('9950', 'Vesper Black Helmet', 'head', 'true', 'none', '550', 'bone', 's', '0', '-1', '83', '0', '0', '5370000', '268', 'true', 'true', 'true', 'true', '0', '0');
INSERT INTO `custom_armor` VALUES ('9951', 'Vesper Black Breastplate', 'chest', 'true', 'heavy', '7620', 'scale_of_dragon', 's', '0', '-1', '205', '0', '0', '14300000', '715', 'true', 'true', 'true', 'true', '0', '0');
INSERT INTO `custom_armor` VALUES ('9952', 'Vesper Black Gaiters', 'legs', 'true', 'heavy', '3260', 'scale_of_dragon', 's', '0', '-1', '128', '0', '0', '8960000', '448', 'true', 'true', 'true', 'true', '0', '0');
INSERT INTO `custom_armor` VALUES ('9953', 'Vesper Black Gauntlets', 'gloves', 'true', 'none', '540', 'leather', 's', '0', '-1', '55', '0', '0', '3580000', '179', 'true', 'true', 'true', 'true', '0', '0');
INSERT INTO `custom_armor` VALUES ('9954', 'Vesper Black Boots', 'feet', 'true', 'none', '1110', 'leather', 's', '0', '-1', '55', '0', '0', '3580000', '179', 'true', 'true', 'true', 'true', '0', '0');
INSERT INTO `custom_armor` VALUES ('9955', 'Vesper Black Leather Armor', 'chest', 'true', 'light', '7620', 'scale_of_dragon', 's', '0', '-1', '205', '0', '0', '14300000', '715', 'true', 'true', 'true', 'true', '0', '0');
INSERT INTO `custom_armor` VALUES ('9956', 'Vesper Black Leggings', 'legs', 'true', 'light', '3260', 'scale_of_dragon', 's', '0', '-1', '128', '0', '0', '8960000', '448', 'true', 'true', 'true', 'true', '0', '0');
INSERT INTO `custom_armor` VALUES ('9957', 'Vesper Black Gloves', 'gloves', 'true', 'none', '540', 'leather', 's', '0', '-1', '55', '0', '0', '3580000', '179', 'true', 'true', 'true', 'true', '0', '0');
INSERT INTO `custom_armor` VALUES ('9958', 'Vesper Black Boots', 'feet', 'true', 'none', '1110', 'leather', 's', '0', '-1', '55', '0', '0', '3580000', '179', 'true', 'true', 'true', 'true', '0', '0');
INSERT INTO `custom_armor` VALUES ('9959', 'Vesper Black Robe Armor', 'chest', 'true', 'magic', '7620', 'scale_of_dragon', 's', '0', '-1', '205', '0', '0', '14300000', '715', 'true', 'true', 'true', 'true', '0', '0');
INSERT INTO `custom_armor` VALUES ('9960', 'Vesper Black Stockings', 'legs', 'true', 'magic', '3260', 'scale_of_dragon', 's', '0', '-1', '128', '0', '0', '8960000', '448', 'true', 'true', 'true', 'true', '0', '0');
INSERT INTO `custom_armor` VALUES ('9961', 'Vesper Black Gauntlets', 'gloves', 'true', 'none', '540', 'leather', 's', '0', '-1', '55', '0', '0', '3580000', '179', 'true', 'true', 'true', 'true', '0', '0');
INSERT INTO `custom_armor` VALUES ('9962', 'Vesper Black Boots', 'feet', 'true', 'none', '1110', 'leather', 's', '0', '-1', '55', '0', '0', '3580000', '179', 'true', 'true', 'true', 'true', '0', '0');

and when i try to execute it it gives me the following error:

[Err] 1136 - Column count doesn't match value count at row 1
[Err] INSERT INTO `custom_armor` VALUES ('9950', 'Vesper Black Helmet', 'head', 'true', 'none', '550', 'bone', 's', '0', '-1', '83', '0', '0', '5370000', '268', 'true', 'true', 'true', 'true', '0', '0');

 

Anybody knows how to fix that kind of errors?I also added by myself 1 item from the 1st code, i restarted the server and when i tried to create it, it couldn't be found.

[Matim]

Compare your table structure with sql structure and correct it, thats all.

[ShuN^]

First of all, thanks for your quick reply.I don't know what you mean exactly.I am newbie in l2 development.I just got started so i can't get your point :P

Could you say it more simple?I mean what i have to do, etc.