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
On Sun, 09 Aug 2009 21:17:15 +0300, "Ralph Deffke"
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 handlin
I should mention that I use MyISAM as storage engine what makes it even more
wiered.
"Nisse Engström" wrote in message
news:91.f7.55947.dc74f...@pb1.pair.com...
> 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 tabl
this is a very good startup for the issue. now the question is where does it
get the value if there is no max(ai) or when I do an insert in an empty
table with the ai field set to 1 where does the innoDB get the next ai value
10720 ?
I assume that the SELECT MAX(ai_col) FROM t FOR UPDATE; return i
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
> change
5 matches
Mail list logo
