github.com/pingcap/tiflow@v0.0.0-20240520035814-5bf52d54e205/tests/integration_tests/common_1/data/test_v5.sql (about)

     1  -- test add and drop columns
     2  USE `common_1`;
     3  
     4  CREATE TABLE `add_and_drop_columns`
     5  (
     6      `id` int(11) NOT NULL PRIMARY KEY
     7  );
     8  
     9  insert into `add_and_drop_columns` (id)
    10  values (1);
    11  
    12  alter table `add_and_drop_columns`
    13      add col1 int null,
    14      add col2 int null,
    15      add col3 int null;
    16  
    17  insert into `add_and_drop_columns` (id, col1, col2, col3)
    18  values (2, 3, 4, 5);
    19  
    20  insert into `add_and_drop_columns` (id) values (3);
    21  
    22  alter table `add_and_drop_columns`
    23      drop col1,
    24      drop col2;
    25  
    26  insert into `add_and_drop_columns` (id, col3)
    27  values (4, 5);