[SOLVED] Resetting auto increment

[Aureole]

I have a table in MYSQL which has a row which is set to auto increment. Because I've been testing my system out so much the id is at around 100 or something.

 

I tried deleting everything from the table but then when I make a new news story the id carries on from where it left off, how can I make it start again from 1?

[per1os]

You can reset an auto_increment field in mySQL by using the following syntax:

alter table <tablename> auto_increment = #; Where # is an integer value.

 

http://www.developer.be/index.cfm/fuseaction/faqDetail/FaqId/187.htm

[Aureole]

Thanks a lot.