List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:February 22 2001 5:32am
Subject:Re: Auto-Inc question
View as plain text  
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
Auto-Inc questionWebsite4S22 Feb
  • Re: Auto-Inc questionPaul DuBois22 Feb
Re: Auto-Inc questionEd Carp22 Feb
Re: Auto-Inc questionWebsite4S22 Feb