1
create table t1 (a int);
2
insert into t1 values (1);
3
insert into t1 values (2);
4
insert into t1 values (3);
5
update t1 set a=a+2 where a=2;
6
update t1 set a=a+2 where a=3;
7
create table t2 (word varchar(20));
8
load data infile '../std_data_ln/words.dat' into table t2;
91
create table t2 (word varchar(20));
92
load data infile '../std_data_ln/words.dat' into table t2;
93
insert into t2 select * from t2;
94
insert into t2 select * from t2;
95
insert into t2 select * from t2;
96
insert into t2 select * from t2;
97
insert into t2 select * from t2;
98
insert into t2 select * from t2;
99
insert into t2 select * from t2;
100
insert into t2 select * from t2;
101
insert into t2 select * from t2;
102
select count(*) from t2;
106
select count(*) from t2;