github.com/dolthub/go-mysql-server@v0.18.0/enginetest/scriptgen/setup/scripts/mytable (about)

     1  exec
     2  create table mytable (i bigint primary key, s varchar(20) comment 'column s' NOT NULL)
     3  ----
     4  
     5  exec
     6  insert into mytable values
     7      (1, 'first row'),
     8      (2, 'second row'),
     9      (3, 'third row')
    10  ----
    11  
    12  exec
    13  create unique index mytable_s on mytable (s)
    14  ----
    15  
    16  exec
    17  create index mytable_i_s on mytable (i,s)
    18  ----
    19  
    20  exec
    21  create index `idx_si` on mytable (`s`,`i`)
    22  ----
    23  
    24  exec
    25  create view myview as SELECT * FROM mytable
    26  ----