Re: MySQL auto_increment fields Server version: 5.1.32-community-log
| From: | Ollisso | Date: | Mon, 10 Aug 2009 23:53:42 +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-296588@lists.php.net to get a copy of this message | ||
On Sun, 09 Aug 2009 21:17:15 +0300, "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 try:ALTER TABLE xxx AUTO_INCREMENT=1; --