实验：基于语句复制的不安全性《MySQL排错指南Page83-85》

use test;

create table f1(char(2))

engine=InnoDB;

begin;

insert into t1 select 1;

insert into t1 select 2;

insert into t1 select 3;

insert into t1 select 4;

insert into t1 select 5;

begin;

insert into t1 select ‘a‘;

insert into t1 select ‘b‘;

insert into t1 select ‘c‘;

insert into t1 select ‘d‘;

insert into t1 select ‘e‘;

insert into t1 select ‘f‘;

commit;

select * from t1;

+------+

| f1   |

+------+

| a    |

| b    |

| c    |

| d    |

| e    |

| f    |

+------+

select * from t1;

+------+

| f1   |

+------+

| a    |

| b    |

| c    |

| d    |

| e    |

| f    |

+------+

select * from t1;

+------+

| f1   |

+------+

| 1    |

| 2    |

| 3    |

| 4    |

| 5    |

| a    |

| b    |

| c    |

| d    |

| e    |

| f    |

+------+

select * from t1;

+------+

| f1   |

+------+

| a    |

| b    |

| c    |

| d    |

| e    |

| f    |

| 1    |

| 2    |

| 3    |

| 4    |

| 5    |

+------+