Page 1 of 1

Restarting auto increment field value within MySQL

Posted: Wed Nov 08, 2006 11:08 pm
by christian_phpbeginner
Hello, I am sure I have read that thread here somewhere. And I have looked for it with the keyword: "Restarting auto increment".....but I don't find anything. So, if you don't mind, could you tell me how can I restart auto increment value back to 1 ?

Thank you very much,
Chris

Posted: Wed Nov 08, 2006 11:11 pm
by Christopher

Posted: Thu Nov 09, 2006 12:09 am
by christian_phpbeginner
Thank you very much, arborint ! Very appreciated !!

Well, I post here once again the code:

Code: Select all

alter table table_name auto_increment = 1;