I am getting the following error:

Column count doesn't match value count at row 1

when I try to run this:

insert into onmylist_person values('value1', 'value2')

My table looks like this:

describe onmylist_person;
+----------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+----------+--------------+------+-----+---------+----------------+
| ID | int(11) | | PRI | NULL | auto_increment |
| username | varchar(16) | | MUL | | |
| person | varchar(255) | | MUL | | |
+----------+--------------+------+-----+---------+----------------+

I know it is because I am only inserting 2 values and the table has 3, but I thought the auto_increment creted an incrementing number automatically.

I want the ID to just be a "counter" incrementing on its own, so i only have to insert the 2 fields.

How do I do this?

Mitch

__________________
Mitch

Hello Mitch,

It is simple...
just make insert statement as folows.

insert into onmylist_person values (null,'value1','value2');

and see mysql automatically inserts value for ID column.
It's really a laughing matter that primary key

Hello,
Continuing my reply......

It's really a laughing matter that we are inserting NULL for primary key col.
and Mysql (just because of auto increment) inserts a vlaue by itself.

Another way..
Table desc.
mysql> desc mytbl;
+-------+-------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------+-------------+------+-----+---------+----------------+
| id | int(11) | | PRI | NULL | auto_increment |
| a | varchar(15) | YES | | NULL | |
| b | varchar(15) | YES | | NULL | |
+-------+-------------+------+-----+---------+----------------+
mysql> insert into mytbl(a,b) values ('x','x');
Query OK, 1 row affected (0.08 sec)

Regards
Milind

Thanks guys, that did it, I did not have enough values.

Mitch