AUTO_INCREMENT Problem.

[Steve Burrus]

Help! I am trying top use the auto-increment statement in a table :

create table if not exists my_table(id smallint NOT NULL AUTO_INCREMENT , MY_NAMES varchar(33) NOT NULL, PRIMARY KEY(id));

insert into my_table (MY_NAMES) values ('Barry', 'Elliott', 'Robin','Bob', 'Steven');

when I try to execute the "insert into" statement I always get this error saying that "the value count doesn't match the column count"! I did the "create table" statement exactly how I saw it done in a book. Where am I going wrong?