exp.test003.ksh

来自「b树实现源码,linux和unix下运行,速度快,极好用」· KSH 代码 · 共 16 行

CREATE TABLE t1 (f1 INT , f2 INT );
CREATE INDEX t1_PRIMARY on t1 ( f1 ) ;
CREATE INDEX t1_idx2 on t1 ( f2 ) ;
SET AUTOCOMMIT OFF;
INSERT INTO t1 VALUES(1,11);
INSERT INTO t1 VALUES(2,21);
INSERT INTO t1 VALUES(3,31);
INSERT INTO t1 VALUES(4,41);
INSERT INTO t1 VALUES(5,51);
INSERT INTO t1 VALUES(6,61);
INSERT INTO t1 VALUES(7,71);
INSERT INTO t1 VALUES(8,81);
INSERT INTO t1 VALUES(9,91);
INSERT INTO t1 VALUES(10,101);
COMMIT;