Re: MySQL auto_increment fields Server version: 5.1.32-community-log
| From: | Nisse Engström | Date: | Tue, 11 Aug 2009 11:35:31 +0000 |
| Subject: | Re: MySQL auto_increment fields Server version: 5.1.32-community-log | ||
| References: | 1 2 3 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-296623@lists.php.net to get a copy of this message | ||
On Mon, 10 Aug 2009 01:17:21 +0200, "Ralph Deffke" wrote:
>> On Sun, 9 Aug 2009 20:17:15 +0200, "Ralph Deffke" wrote:
>>
>>> 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
>
> I should mention that I use MyISAM as storage engine what makes it even more
> wiered.
Also check out auto_increment_offset (introduced in 5.0.2):
<http://dev.mysql.com/doc/refman/5.0/en/replication-options-master.html#sysvar_auto_increment_offset>
/Nisse