Re: About AUTO-INC In “interleaved” lock mode

[five small]

So..you mean I was wrong with these two transcations:

tx1:insert into t1(c2) select c2 from t2;
tx2:insert into t1 values(null,"b"),(1500000,"b"),(null,"b"),(null,"b");

And I start tx1 first,what I should point is,There are more than 2,000,000 rows in t2,so this code in tx1 takes too much time to execute.

Almost at the same time..

I start tx2,..

I think multiple statements(tx1 and tx2) can be generating numbers at the same time.I can't find my own mistakes.

Please Point out my mistake , i really don't know what is "2 executable scripts" like you said,and what difference between my test and "2 executable scripts"....

Thank U very much...