github.com/matrixorigin/matrixone@v1.2.0/test/distributed/cases/comment/annotion.result (about)

     1  create database if not exists test;
     2  use test;
     3  drop table if exists tlonglonglong;
     4  CREATE TABLE table01(
     5  c1 BIGINT NOT NULL AUTO_INCREMENT,
     6  c2 VARCHAR(200) NULL,
     7  c3 VARCHAR(200) NULL,
     8  c4 VARCHAR(200) NULL,
     9  c5 VARCHAR(200) NULL,
    10  c6 TINYINT NULL,
    11  c7 DATETIME NULL,
    12  c8 VARCHAR(200) NULL,
    13  c9 TINYINT NOT NULL,
    14  PRIMARY KEY (`c1`) USING BTREE
    15  )ENGINE=INNODB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
    16  show tables;
    17  Tables_in_test
    18  table01
    19  show create table table01;
    20  Table    Create Table
    21  table01    CREATE TABLE `table01` (\n`c1` BIGINT NOT NULL AUTO_INCREMENT,\n`c2` VARCHAR(200) DEFAULT NULL,\n`c3` VARCHAR(200) DEFAULT NULL,\n`c4` VARCHAR(200) DEFAULT NULL,\n`c5` VARCHAR(200) DEFAULT NULL,\n`c6` TINYINT DEFAULT NULL,\n`c7` DATETIME DEFAULT NULL,\n`c8` VARCHAR(200) DEFAULT NULL,\n`c9` TINYINT NOT NULL,\nPRIMARY KEY (`c1`)\n)
    22  drop table table01;
    23  drop table if exists table02;
    24  create table table02(id int PRIMARY KEY,name VARCHAR(255),age int);
    25  insert into table02 values(1,"Abby", 24);
    26  insert into table02 values(2,"Bob", 25);
    27  insert into table02 values(3,"Carol", 23);
    28  insert into table02 values(4,"Dora", 29);
    29  create unique index idx on table02(name);
    30  select * from table02;
    31  id    name    age
    32  1    Abby    24
    33  2    Bob    25
    34  3    Carol    23
    35  4    Dora    29
    36  show create table table02;
    37  Table    Create Table
    38  table02    CREATE TABLE `table02` (\n`id` INT NOT NULL,\n`name` VARCHAR(255) DEFAULT NULL,\n`age` INT DEFAULT NULL,\nPRIMARY KEY (`id`),\nUNIQUE KEY `idx` (`name`)\n)
    39  drop table table02;
    40  drop database test;