At 12:24 AM -0500 2/22/01, [EMAIL PROTECTED] wrote:
>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.
Drop the table and recreate it, or issue this query:
DELETE FROM tbl_name
--
Paul DuBois, [EMAIL PROTECTED]
---------------------------------------------------------------------
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
