1
by brian
clean slate |
1 |
create table t1 (a int not null auto_increment, primary key (a)) engine=myisam; |
2 |
set @@session.auto_increment_increment=1, @@session.auto_increment_offset=1; |
|
3 |
insert delayed into t1 values (207); |
|
4 |
insert delayed into t1 values (null); |
|
5 |
insert delayed into t1 values (300); |
|
6 |
show binlog events from <binlog_start>; |
|
7 |
Log_name Pos Event_type Server_id End_log_pos Info |
|
8 |
master-bin.000001 # Query # # use `test`; create table t1 (a int not null auto_increment, primary key (a)) engine=myisam |
|
9 |
master-bin.000001 # Query # # use `test`; insert delayed into t1 values (207) |
|
10 |
master-bin.000001 # Intvar # # INSERT_ID=208 |
|
11 |
master-bin.000001 # Query # # use `test`; insert delayed into t1 values (null) |
|
12 |
master-bin.000001 # Query # # use `test`; insert delayed into t1 values (300) |
|
13 |
insert delayed into t1 values (null),(null),(null),(null); |
|
14 |
insert delayed into t1 values (null),(null),(400),(null); |
|
15 |
11 == 11 |
|
16 |
select * from t1; |
|
17 |
a
|
|
18 |
207
|
|
19 |
208
|
|
20 |
300
|
|
21 |
301
|
|
22 |
302
|
|
23 |
303
|
|
24 |
304
|
|
25 |
305
|
|
26 |
306
|
|
27 |
400
|
|
28 |
401
|
|
29 |
drop table t1; |