Reinitializing an autoincrement column

[jrhitokiri]

i have been working on a project with an autoincrement column. as i tested continually, the increments reached about 2500. now, with the project finished, how do i reset the autoincrement counter back to zero? even if i erase all my data in the tables, the autoincrement keeps on counting higher than 2500. how do i get it back to zero?

thanks!

PS. im using phpmyadmin, if that's any help

[Markus]

Helle there!

You can use this:
[php]
ALTER TABLE `table_name`
AUTO_INCREMENT = 0
[/php]

Cheers :)

[ronverdonk]

This is NOT a php question, but a MySQL one. I will move this thread.\ to the MySQL forum.

moderator

[ashokkumarpdi]

Hi,

if you want to delete all the records from the table, user the tuncate statement to delete all the records. It will delete all ur records and automatically rest ur auto increment value. Otherwise you have to rest the value manually by the alter table statement.


Ex:

TRUNACATE TABLE <table_name>;

else

use the above method.


Regards,
S.Ashokkumar

[jrhitokiri]

This is NOT a php question, but a MySQL one. I will move this thread.\ to the MySQL forum.

moderator

oh, okay, im sorry. you could delete this now. problem solved.. ^_^

thanks for those who helped out