[BG1]

I'm trying to insert values into my table, but it doesn't seem to work anymore I get an error message stating;

"ERROR 1136 (21S01): Column count doesn't match value count at row 1"

I have no clue what it is about, googled for information, but got varying results...

This is my table;

CREATE TABLE toys (toy_id INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY, toy VARCHAR(20));

Query OK, 0 rows affected (0.33 sec)

INSERT INTO toys (toy_id, toy) VALUES ('', 'hula hoop', '', 'balsa glider');
ERROR 1136 (21S01): Column count doesn't match value count at row 1

[tonyvh37]

Thats because you have to have two insert statements. The statement you have now is trying to insert ", 'hulahoop,'" into the toy_id column and 'balsa glider' into the toy column. what you need is something like this

INSERT INTO Toys (toy)
    VALUES ('hula hoop') /*not sure what the extra , and "" are for*/
INSERT INTO Toys (toy)
    VALUES ('balsa glider')

You don't need to insert the toy_id because you are using an auto incrementing value and the DB will take care of that. However, you cannot add more than one row into your table with one insert statement. A new row = a new insert statement. Hopefully that helps.

[louisc]

BG1, you have a slight syntax problem. When you want to insert multiple rows, you need to write the statement a little differently. What you should have done is this:

INSERT INTO toys (toy_id, toy) VALUES ('', 'hula hoop'), ('', 'balsa glider');

There are a few alternatives. Instead of using the somewhat confusing empty quotes, you can use DEFAULT like this:

INSERT INTO toys (toy_id, toy) VALUES
(DEFAULT, 'hula hoop'),
(DEFAULT, 'balsa glider');

Or even better, let toy_id take care of itself and write this:

INSERT INTO toys (toy) VALUES
('hula hoop'),
('balsa glider');

[BG1]

I should stop working on this late at night I guess, 'cause this was a bit obvious... :oops:

Anyways, thanks again for helping me out, I was pulling hair out of my skull allready