Mysql auto_increment

[Anon]

Hi... i would like to know if mysql auto_increment funtion can do this.

Do not repeat the id already inserted, even if it have been deleted.

MSSQl does it, the auto_increment ids are uniques and will never appear again, even if you delete them, it keeps going on the next NEW addigned ID.

Thanks!

Alejandro.

[Anon]

I'm pretty sure that is the default behavior for MySQL. I also thing you can manually "reset" the autoincrement number back to zero if needed.

check mysql.com for the docs to be sure.

[lawnmowerman]

You are correct on both points.

Just my $0.02 🙂

-Rich