ALTER TABLE T1 AUTO_INCREMENT=1;
It's likely that you dropped every record and expected the auto_increment to
reset.

Jerry Wilborn
jerrywilb...@gmail.com


On Sun, Aug 9, 2009 at 1:17 PM, Ralph Deffke <ralph_def...@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_def...@yahoo.de
>
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>

Reply via email to