Generate dummy data quickly

//////////////////////////////////

// Oracle

//////////////////////////////////

drop table t1;

create table t1 (c1 char(20));

insert /*+ APPEND */ into t1 select rownum from dual connect by level <=1000000;

commit;

select count(*) from t1;

//////////////////////////////////

// Timesten 7

//////////////////////////////////

autocommit on;

drop table TEST.T1;

create table test.t1 (c1 char(20));

insert into t1 select a.rowid from sys.columns a cross join sys.columns b;

select count(*) from t1;

//////////////////////////////////

// Timesten 11

//////////////////////////////////

drop table TEST.T1;

create table test.t1 (c1 char(20));

insert into t1 select a.rowid from sys.columns a cross join sys.columns b;

select count(*) from t1;

commit;

//////////////////////////////////

// MS-SQL

//////////////////////////////////

drop table t1;

create table t1 (c1 char(128));

insert into t1(c1) select top 480000 newid() from sys.columns a cross join sys.columns b;

insert into t1(c1) select top 480000 newid() from sys.columns a cross join sys.columns b;

select count(*) from t1;

//////////////////////////////////

// MySQL

//////////////////////////////////

drop table test.t1;

create table test.t1 (c1 char(20));

/* 1,000,000  */

insert into test.t1 (c1) select @row := @row + 1 from

(select 0 union all select 1 union all select 2 union all select 3 union all select 4 union all select 5 union all select 6 union all select 7 union all select 8 union all select 9) t,

(select 0 union all select 1 union all select 2 union all select 3 union all select 4 union all select 5 union all select 6 union all select 7 union all select 8 union all select 9) t1,

(select 0 union all select 1 union all select 2 union all select 3 union all select 4 union all select 5 union all select 6 union all select 7 union all select 8 union all select 9) t2,

(select 0 union all select 1 union all select 2 union all select 3 union all select 4 union all select 5 union all select 6 union all select 7 union all select 8 union all select 9) t3,

(select 0 union all select 1 union all select 2 union all select 3 union all select 4 union all select 5 union all select 6 union all select 7 union all select 8 union all select 9) t4,

(select 0 union all select 1 union all select 2 union all select 3 union all select 4 union all select 5 union all select 6 union all select 7 union all select 8 union all select 9) t5

;

//////////////////////////////////

// Informix

//////////////////////////////////

drop table t1;

create table t1 (c1 varchar(128));

insert into t1(c1) select a.rowid from syscolumns a cross join syscolumns b;

select count(*) from t1;

//////////////////////////////////

//Altibase 6.5.1

//////////////////////////////////

drop table t1;

create table t1 (c1 char(20));

insert /*+ APPEND */ into t1 select rownum from dual connect by level <=1000000;

commit;

select count(*) from t1;

//////////////////////////////////

// Tibero

//////////////////////////////////

drop table t1;

create table test.t1 (c1 char(20));

insert into t1 select rownum from dual connect by level <=100000

//////////////////////////////////

// CUBRID 9.x

//////////////////////////////////

drop table t1;

create table t1 (c1 int);

insert into t1 select rownum+1 from

                  table({0,1,2,3,4,5,6,7,8,9}) t0(a),

                  table({0,1,2,3,4,5,6,7,8,9}) t1(a), -- 100

                  table({0,1,2,3,4,5,6,7,8,9}) t2(a), -- 1,000

                  table({0,1,2,3,4,5,6,7,8,9}) t3(a), -- 10,000

                  table({0,1,2,3,4,5,6,7,8,9}) t4(a), -- 100,000

                  table({0,1,2,3,4,5,6,7,8,9}) t5(a)  -- 1,000,000