Re: MySQL auto_increment fields Server version: 5.1.32-community-log
| From: | Jerry Wilborn | Date: | Sun, 09 Aug 2009 19:02:12 +0000 |
| Subject: | Re: MySQL auto_increment fields Server version: 5.1.32-community-log | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-296516@lists.php.net to get a copy of this message | ||
ALTER TABLE T1 AUTO_INCREMENT=1;
It's likely that you dropped every record and expected the auto_increment to
reset.
Jerry Wilborn
jerrywilborn@gmail.com
On Sun, Aug 9, 2009 at 1:17 PM, Ralph Deffke <ralph_deffke@yahoo.de> wrote:
> Hi all,
>
> I'm facing the fact that it seems that auto_increment fields in a table not
> start at 1 like it was in earlier versions even if I install mySQL brand
> new
> creating all tables new. it seems to me that auto_increments handling has
> changed to older version. is somebody out there who can give me a quick
> background about auto_increment and how and if I can control the behavior
> of
> mySQL about them.
>
> ralph_deffke@yahoo.de
>
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>