At 6:03 PM -0500 9/25/01, [EMAIL PROTECTED] wrote:
>Hi All,
>
>I seen a post a few days ago on how to set the auto increment value
>back to one
>after deleting all the data from a table. I suppose I could just re-create the
>table, but thought it be simpler to just alter the table to reset the auto
>increment value back to 1. what exactly is the "alter" syntax to reset it??
If you saw a post, then the link at the bottom of each message indicates
how to get to the list archive. You'll find the answer there. Often
a useful strategy. In any case, the answer is:
ALTER TABLE tbl_name AUTO_INCREMENT = 1
>
>thx's
>
>mysql database
>
>Mike(mickalo)Blezien
>=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
>Thunder Rain Internet Publishing
>Providing Internet Solutions that work!
>http://www.thunder-rain.com
>Tel: 1(225)686-2002
>=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
>
>
>---------------------------------------------------------------------
>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
--
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