github.com/pingcap/tiflow@v0.0.0-20240520035814-5bf52d54e205/dm/tests/sharding2/data/db1.increment2.sql (about)

     1  alter table sharding22.t1 add column name varchar(20);
     2  alter table sharding22.t1 add index abc(name);
     3  
     4  insert into sharding22.t1 values(1, "a"), (2, "b");
     5  insert into sharding22.t1 values(3, "c"), (4, "d");
     6  insert into sharding22.t1 values(5, "e"), (6, "f");
     7  
     8  alter table sharding22.t1 add column c int;
     9  alter table sharding22.t1 add index c(c);
    10  alter table sharding22.t1 add column d int;
    11  alter table sharding22.t1 add index d(d);
    12  alter table sharding22.t1 add column e int, add index e(e);
    13  
    14  insert into sharding22.t1 values(7, "g", 7, 7, 7);
    15  insert into sharding22.t1 values(8, "h", 8, 8, 8);
    16  insert into sharding22.t1 values(9, "i", 9, 9, 9);
    17  
    18  alter table sharding22.t1 add column f int;