Hi folks!

I'd like to know if someone can help me with the following...
I've got a table in MySQL with an auto_increment field, there's 59 registers, but if I insert one more register the auto_increment field will take the value 65, because I've deleted the registers with the values 60,61,...,64.
How can I reset the counter to make the next value=60?

Thanks!
Fernando.

ALTER TABLE table_name AUTO_INCREMENT = 60;


From the MySQL manual:
  http://www.mysql.com/doc/en/example-AUTO_INCREMENT.html


Take care,

Nik
http://www.bigaction.org/