Mysql auto_increment problem.

wood · 02-25-2004, 03:53 AM

I have assign an auto increment to a column, but after I have delete everything, and insert a new record. the number doesn't go back to 1, and it continue to the next number. How can I solve it

Hko · 02-25-2004, 10:40 AM

Usually you don;t need to, because most of the times, AUTO_INCREMENT columns are used only to have unique (prim. key) values. i.e. the values do not have a meaning other than being unique.

But if you want to you can specify a value of 1 for the first record you insert into the empty table.