[EMAIL PROTECTED] ([EMAIL PROTECTED]) writes:
> 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.
30 seconds work(less time than it took you to type your email) would've revealed the
answer:
1. Click on "the manual" link at the bottom of this message.
2. See the search box? Type in "auto increment".
3. Click on the "myisamchk" link.
4. Read.
Or, to make it even easier:
http://www.mysql.com/doc/m/y/myisamchk_other_options.html
Please, next time, bother to search the manual before wasting other's time answering
questions to which 30 seconds research would reveal the answer.
--
Ed Carp, N7EKG [EMAIL PROTECTED] 940/367-2744 cell phone
http://www.pobox.com/~erc [EMAIL PROTECTED] - text pager
I sometimes wonder if the American people deserve to be free - they seem
so unwilling to fight to preserve the few freedoms they have left.
---------------------------------------------------------------------
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
