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?

Code:
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