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

[expired user #5035]'s profile image [expired user #5035] posted 14 years ago in General Permalink
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?
jfalch's profile image jfalch posted 14 years ago Permalink
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.