github.com/matrixorigin/matrixone@v0.7.0/test/distributed/cases/table/truncate_table.result (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 INSERT INTO emp VALUES (1,'SMITH','CLERK',7902,'1980-12-17',800,NULL,20); 14 INSERT INTO emp VALUES (2,'ALLEN','SALESMAN',7698,'1981-02-20',1600,300,30); 15 INSERT INTO emp VALUES (3,'WARD','SALESMAN',7698,'1981-02-22',1250,500,30); 16 INSERT INTO emp VALUES (4,'JONES','MANAGER',7839,'1981-04-02',2975,NULL,20); 17 INSERT INTO emp VALUES (5,'MARTIN','SALESMAN',7698,'1981-09-28',1250,1400,30); 18 INSERT INTO emp VALUES (6,'BLAKE','MANAGER',7839,'1981-05-01',2850,NULL,30); 19 INSERT INTO emp VALUES (7,'CLARK','MANAGER',7839,'1981-06-09',2450,NULL,10); 20 INSERT INTO emp VALUES (8,'SCOTT','ANALYST',7566,'0087-07-13',3000,NULL,20); 21 INSERT INTO emp VALUES (9,'KING','PRESIDENT',NULL,'1981-11-17',5000,NULL,10); 22 INSERT INTO emp VALUES (10,'TURNER','SALESMAN',7698,'1981-09-08',1500,0,30); 23 SELECT * FROM EMP; 24 empno ename job mgr hiredate sal comm deptno 25 1 SMITH CLERK 7902 1980-12-17 800.00 null 20 26 2 ALLEN SALESMAN 7698 1981-02-20 1600.00 300.00 30 27 3 WARD SALESMAN 7698 1981-02-22 1250.00 500.00 30 28 4 JONES MANAGER 7839 1981-04-02 2975.00 null 20 29 5 MARTIN SALESMAN 7698 1981-09-28 1250.00 1400.00 30 30 6 BLAKE MANAGER 7839 1981-05-01 2850.00 null 30 31 7 CLARK MANAGER 7839 1981-06-09 2450.00 null 10 32 8 SCOTT ANALYST 7566 0087-07-13 3000.00 null 20 33 9 KING PRESIDENT null 1981-11-17 5000.00 null 10 34 10 TURNER SALESMAN 7698 1981-09-08 1500.00 0.00 30 35 truncate table emp; 36 INSERT INTO emp VALUES (1,'SMITH','CLERK',7902,'1980-12-17',800,NULL,20); 37 INSERT INTO emp VALUES (2,'ALLEN','SALESMAN',7698,'1981-02-20',1600,300,30); 38 INSERT INTO emp VALUES (3,'WARD','SALESMAN',7698,'1981-02-22',1250,500,30); 39 INSERT INTO emp VALUES (4,'JONES','MANAGER',7839,'1981-04-02',2975,NULL,20); 40 INSERT INTO emp VALUES (5,'MARTIN','SALESMAN',7698,'1981-09-28',1250,1400,30); 41 INSERT INTO emp VALUES (6,'BLAKE','MANAGER',7839,'1981-05-01',2850,NULL,30); 42 INSERT INTO emp VALUES (7,'CLARK','MANAGER',7839,'1981-06-09',2450,NULL,10); 43 INSERT INTO emp VALUES (8,'SCOTT','ANALYST',7566,'0087-07-13',3000,NULL,20); 44 INSERT INTO emp VALUES (9,'KING','PRESIDENT',NULL,'1981-11-17',5000,NULL,10); 45 INSERT INTO emp VALUES (10,'TURNER','SALESMAN',7698,'1981-09-08',1500,0,30); 46 SELECT * FROM EMP; 47 empno ename job mgr hiredate sal comm deptno 48 1 SMITH CLERK 7902 1980-12-17 800.00 null 20 49 2 ALLEN SALESMAN 7698 1981-02-20 1600.00 300.00 30 50 3 WARD SALESMAN 7698 1981-02-22 1250.00 500.00 30 51 4 JONES MANAGER 7839 1981-04-02 2975.00 null 20 52 5 MARTIN SALESMAN 7698 1981-09-28 1250.00 1400.00 30 53 6 BLAKE MANAGER 7839 1981-05-01 2850.00 null 30 54 7 CLARK MANAGER 7839 1981-06-09 2450.00 null 10 55 8 SCOTT ANALYST 7566 0087-07-13 3000.00 null 20 56 9 KING PRESIDENT null 1981-11-17 5000.00 null 10 57 10 TURNER SALESMAN 7698 1981-09-08 1500.00 0.00 30 58 DROP TABLE emp;