How to automatically increment value in mysql

[dkhansoft]

hi,
i have created one table called user_details for this table there is one
column called uid,which should increment automatically,when ever i insert
values

for this i have create table by using auto_increment,table created seccussfully,
bt if i insert values into this table by excluding tat uid(which is increment automatically),it is showing error column count doesnt match value of row count.

anybody knows where i was error,
ur reply greatly appreciate.

thanks
khan

[code green]

i insert values into this table by excluding tat uid

Not sure what you are doing here but you must define the field names along with the values

[mwasif]

You should provide the filed names in the query leaving uid. e.g.

INSERT INTO table_name (firstname, lastname) VALUES ('M', 'Wasif')

Or without field names

INSERT INTO table_name VALUES ('', 'M', 'Wasif')

OR

INSERT INTO table_name VALUES (NULL, 'M', 'Wasif')

The first method is preferable.