Hi,
I have a table which contains a row called ListID which is set to auto
increment, I added a load of test data into the table while I built my
website so I could test various things out, anyway that is all finished now
and I am ready to go live so I have dropped all the test data from the table.
My question is how to I get the ListID to start back at 0 as at the moment
even though all the fake content is gone it is still incrementing from the
last record. Thats not to say I wasn`t expecting it, I`m just not sure how to
reset the increment.
TIA
Ade
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
