I've got an INSERT statement which just won't work, I keep getting the dreaded:
Now I've checked and triple checked the row in question and the values I'm inserting are exactly the right amount for the table, so I'm at a loss!ERROR 1136: Column count doesn't match value count at row 45
Here's the create table:
Code: Select all
CREATE TABLE client (
client_id int(11) NOT NULL auto_increment,
second_name varchar(255) NOT NULL,
first_name varchar(255) NOT NULL,
invoice_address_1 varchar(255) NOT NULL,
invoice_address_2 varchar(255) NOT NULL,
invoice_address_3 varchar(255) NOT NULL,
invoice_town_city varchar(255) NOT NULL,
invoice_postcode varchar(7) NOT NULL,
mobile_number int(20) NOT NULL,
landline_number int(20),
email varchar(255) NOT NULL,
company_name varchar(255) NOT NULL,
notes text(1024),
contact_date date NOT NULL,
PRIMARY KEY (client_id)
);Code: Select all
('','Smith','John','4 Upper Road','','Borham','London','N10 2XX','07771 111 2222','','john.smith@mail.com','N/A','',''),Any clue at all, what's going on? A bug?
Thanks for any help.