inset in mysql with auto_increment,

[sql]

hi all , I have a simple table in mysql

drop  table  setrules  if exists setrules;
create table setrules(
   ID int(10) unsigned NOT NULL auto_increment,
  STime  time NOT NULL default '00:00:00',
  ETime    time  Not NULL    default    '00:00:00' ,
  DATE date NOT NULL default '0000-00-00',
  Primary key(ID));
insert into setrules
values(2 , '12:00:00', '13:00:00', '2006-11-14')

why I need to insert 2 in here , when the id is set to auto_ increment, why I still need to insert the ID number ?
Thank you
________
NEW JERSEY MEDICAL MARIJUANA DISPENSARY

[rmiao]

Does insert statement work if you take out id number?

[mikr0s]

You dont have to set manually the value of an auto increment field UNLESS you want to.
MySql allows the manual value adjustment on auto increment fields.

--HTH--

[sql]

the problem is I have to insert the Id number by hand , other wise I will got something like Colum conut doesn't match value count at row 1,
that is the problem for me, since we will use in on web how can the user know what is the id number it suppose be, do I create my table wrong ,? what stuid mistake I made?
Thank you
________
TRICHOMES PICTURES

[mikr0s]

Note: It is better practise to write/mention the columns of the table:

insert into setrules(STime, ETime, Date)
values('12:00:00', '13:00:00', '2006-11-14')

OR

insert into setrules(ID, STime, ETime, Date)
values(NULL, '12:00:00', '13:00:00', '2006-11-14')

OR

insert into setrules
values(NULL, '12:00:00', '13:00:00', '2006-11-14')

by supplying NULL to an autoincrement field, MySql adds the next available value to this field

--HTH--