how to make a unique key 1 again?

[shedokan]

I want to makea unique number 1 again.
how?

[Fumigator]

Are you talking about an auto-increment column? And you want to reset it to 1?

http://dev.mysql.com/doc/refman/4.1/en/example-auto-increment.html

[shedokan]

yes exactly.

[shedokan]

never mnd I found a solution:
ALTER TABLE yourtablehere AUTO_INCREMENT=1

[Fumigator]

Yeah that command was in the link I provided.