Query about an SQL Error

registered · Regular Joined: Sep 14, 2003 Posts: 74

Hi people,

I am trying to install a program that uses MySQL and have run into a small problem, which I am unable to resolve due to my lack of MySQL Programing knowledge!

More specifically, I've created a table using the following code:

CREATE TABLE categories (
id int(11) NOT NULL auto_increment,
name varchar(255) NOT NULL default '',
PRIMARY KEY (id)
) TYPE=MyISAM;

Then enter the following command:

INSERT INTO categories VALUES('1', '1','default');

When executing the above in MySQL Front, I receive the following error:

Column count doesn't match value count at row 1

Can someone help me resolve this ?

Cheers,

Posted: Fri Oct 01, 2004 2:24 pm

Just and update,

I have figured out the problem - simple one aswell!

Removing one '1' did the job, so:

INSERT INTO categories VALUES('1', '1','default');

became

INSERT INTO categories VALUES('1','default');

Cheers,