At 12:24 AM -0500 2/22/01, Website4S@stripped wrote:
>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, paul@stripped