create and insert throwing error.

[IBazz]

Hi,

Getting back into this after a couple of weeks away.

I am creating a table and then trying to insert values. MySQL throws the error 1136, and says that column count doesn't match value count at row 1.

what am I missing please?

CREATE TABLE IF NOT EXISTS vat_rates
( vat_rate decimal(5,2) NOT NULL
, date_from date NOT NULL
, date_to date default NULL
, PRIMARY KEY  (vat_rate,date_from)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

INSERT INTO vat_rates (vat_rate) VALUES
('17.5', '2008-04-05', ''),
('15.00', '2008-12-01', '');

bazz

[r937]

this one's easy, bazz, you just gots to think a little harder

"column count doesn't match value count"

let's see...

INSERT INTO vat_rates (vat_rate)

okay, that's 1 column...

 VALUES ('17.5', '2008-04-05', '')

and that's 3 values

see it now?

[IBazz]

yep I got it, just now, when I hit the same issue with another table. I'll have to build up my momentum again.

Thanks Rudy.