github.com/matrixorigin/matrixone@v0.7.0/test/distributed/cases/table/truncate_table.sql (about)

     1  DROP TABLE IF EXISTS emp;
     2  create table emp(
     3  empno int auto_increment COMMENT '雇员编号',
     4  ename varchar(15) COMMENT '雇员姓名',
     5  job varchar(10) COMMENT '雇员职位',
     6  mgr int unsigned COMMENT '雇员对应的领导的编号',
     7  hiredate date COMMENT '雇员的雇佣日期',
     8  sal decimal(7,2) COMMENT '雇员的基本工资',
     9  comm decimal(7,2) COMMENT '奖金',
    10  deptno int unsigned COMMENT '所在部门',
    11  primary key(empno)
    12  ) COMMENT='雇员表';
    13  
    14  INSERT INTO emp VALUES (1,'SMITH','CLERK',7902,'1980-12-17',800,NULL,20);
    15  INSERT INTO emp VALUES (2,'ALLEN','SALESMAN',7698,'1981-02-20',1600,300,30);
    16  INSERT INTO emp VALUES (3,'WARD','SALESMAN',7698,'1981-02-22',1250,500,30);
    17  INSERT INTO emp VALUES (4,'JONES','MANAGER',7839,'1981-04-02',2975,NULL,20);
    18  INSERT INTO emp VALUES (5,'MARTIN','SALESMAN',7698,'1981-09-28',1250,1400,30);
    19  INSERT INTO emp VALUES (6,'BLAKE','MANAGER',7839,'1981-05-01',2850,NULL,30);
    20  INSERT INTO emp VALUES (7,'CLARK','MANAGER',7839,'1981-06-09',2450,NULL,10);
    21  INSERT INTO emp VALUES (8,'SCOTT','ANALYST',7566,'0087-07-13',3000,NULL,20);
    22  INSERT INTO emp VALUES (9,'KING','PRESIDENT',NULL,'1981-11-17',5000,NULL,10);
    23  INSERT INTO emp VALUES (10,'TURNER','SALESMAN',7698,'1981-09-08',1500,0,30);
    24  SELECT * FROM EMP;
    25  truncate table emp;
    26  INSERT INTO emp VALUES (1,'SMITH','CLERK',7902,'1980-12-17',800,NULL,20);
    27  INSERT INTO emp VALUES (2,'ALLEN','SALESMAN',7698,'1981-02-20',1600,300,30);
    28  INSERT INTO emp VALUES (3,'WARD','SALESMAN',7698,'1981-02-22',1250,500,30);
    29  INSERT INTO emp VALUES (4,'JONES','MANAGER',7839,'1981-04-02',2975,NULL,20);
    30  INSERT INTO emp VALUES (5,'MARTIN','SALESMAN',7698,'1981-09-28',1250,1400,30);
    31  INSERT INTO emp VALUES (6,'BLAKE','MANAGER',7839,'1981-05-01',2850,NULL,30);
    32  INSERT INTO emp VALUES (7,'CLARK','MANAGER',7839,'1981-06-09',2450,NULL,10);
    33  INSERT INTO emp VALUES (8,'SCOTT','ANALYST',7566,'0087-07-13',3000,NULL,20);
    34  INSERT INTO emp VALUES (9,'KING','PRESIDENT',NULL,'1981-11-17',5000,NULL,10);
    35  INSERT INTO emp VALUES (10,'TURNER','SALESMAN',7698,'1981-09-08',1500,0,30);
    36  SELECT * FROM EMP;
    37  DROP TABLE emp;