Ads were blocked by your webbrowser.

This is not a problem, but keep in mind that developing HeidiSQL, user support and hosting takes time and money.

You may want to send a donation instead.

sql error

horrificslyer posted 3 months ago in General

here is the file i want to put in my navicat :- INSERT INTO armor VALUES (10910, 'Angel', 'face', 'false', 'none', 10, 'none', 0, -1, 0, 0, 0, 5000000, 0, 'true', 'true', 'true', 'true', 0, 0); INSERT INTO armor VALUES (10911, 'Fallen', 'face', 'false', 'none', 10, 'none', 0, -1, 0, 0, 0, 5000000, 0, 'true', 'true', 'true', 'true', 0, 0); INSERT INTO armor VALUES (10912, 'Pixie', 'face', 'false', 'none', 10, 'none', 0, -1, 0, 0, 0, 5000000, 0, 'true', 'true', 'true', 'true', 0, 0); INSERT INTO armor VALUES (10913, 'Chaos', 'face', 'false', 'none', 10, 'none', 0, -1, 0, 0, 0, 5000000, 0, 'true', 'true', 'true', 'true', 0, 0); INSERT INTO armor VALUES (10914, 'Eva', 'face', 'false', 'none', 10, 'none', 0, -1, 0, 0, 0, 5000000, 0, 'true', 'true', 'true', 'true', 0, 0); INSERT INTO armor VALUES (10915, 'Netherworld', 'face', 'false', 'none', 10, 'none', 0, -1, 0, 0, 0, 5000000, 0, 'true', 'true', 'true', 'true', 0, 0); INSERT INTO armor VALUES (10916, 'Succubus', 'face', 'false', 'none', 10, 'none', 0, -1, 0, 0, 0, 5000000, 0, 'true', 'true', 'true', 'true', 0, 0); INSERT INTO armor VALUES (10917, 'Gargoyle', 'face', 'false', 'none', 10, 'none', 0, -1, 0, 0, 0, 5000000, 0, 'true', 'true', 'true', 'true', 0, 0);

============================================ and it gives me this error :- [SQL] Query epicwings start [ERR] 1136 - Column count doesn't match value count at row 1 [ERR] INSERT INTO armor VALUES (10910, 'Angel', 'face', 'false', 'none', 10, 'none', 0, -1, 0, 0, 0, 5000000, 0, 'true', 'true', 'true', 'true', 0, 0); INSERT INTO armor VALUES (10911, 'Fallen', 'face', 'false', 'none', 10, 'none', 0, -1, 0, 0, 0, 5000000, 0, 'true', 'true', 'true', 'true', 0, 0); INSERT INTO armor VALUES (10912, 'Pixie', 'face', 'false', 'none', 10, 'none', 0, -1, 0, 0, 0, 5000000, 0, 'true', 'true', 'true', 'true', 0, 0); INSERT INTO armor VALUES (10913, 'Chaos', 'face', 'false', 'none', 10, 'none', 0, -1, 0, 0, 0, 5000000, 0, 'true', 'true', 'true', 'true', 0, 0); INSERT INTO armor VALUES (10914, 'Eva', 'face', 'false', 'none', 10, 'none', 0, -1, 0, 0, 0, 5000000, 0, 'true', 'true', 'true', 'true', 0, 0); INSERT INTO armor VALUES (10915, 'Netherworld', 'face', 'false', 'none', 10, 'none', 0, -1, 0, 0, 0, 5000000, 0, 'true', 'true', 'true', 'true', 0, 0); INSERT INTO armor VALUES (10916, 'Succubus', 'face', 'false', 'none', 10, 'none', 0, -1, 0, 0, 0, 5000000, 0, 'true', 'true', 'true', 'true', 0, 0); INSERT INTO armor VALUES (10917, 'Gargoyle', 'face', 'false', 'none', 10, 'none', 0, -1, 0, 0, 0, 5000000, 0, 'true', 'true', 'true', 'true', 0, 0); [SQL] Finished with error

thanks for any help

Please login to leave a reply, or register at first.