SQL Error (1136): Column count doesn't match value count at row 1

User, date Message
Written by goodc181
4 years ago
Category: General
3 posts since Mon, 05 Jul 10
INSERT INTO `worldmap_info` VALUES ('451', '451', '0', '100', '1', '0', '0', '0', '0', 'programmer island', '3', '0', '0', '0', '0', '0', '0', '100', '0');

that gives me that error
anyone know a solution?
Written by jfalchMoney, Euro
4 years ago
406 posts since Sat, 17 Oct 09
the number of values in the list after VALUES is not the same as the number of fields in the database table 'worldmap'. put in more or less values, depending on this number of fields. you can see the fields if you double click first the database name (on the left), then the table name 'worldmap' below it, then on the "Table: worldmap" tab on the right.

if that does not help you, a) search in wow forums (this isnt one), b) learn what a database/table/field is, and some sql (this is not a newbie forum for 'database? no idea').

you basically just walked into a car mechanic shop and asked "my car is suddenly out of gas - can you tell me why ?? can you fix it?"

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