|
1
by brian
clean slate |
1 |
drop table if exists t1,t2; |
2 |
CREATE TABLE `t1` ( |
|
|
500
by Brian Aker
Re-enabled more tests. |
3 |
`id` int NOT NULL default '0', |
4 |
`id2` int NOT NULL default '0', |
|
5 |
`id3` int NOT NULL default '0'); |
|
|
1
by brian
clean slate |
6 |
create table t2 select id2 from t1 order by id3; |
7 |
select count(*) from t2; |
|
8 |
count(*) |
|
9 |
4000
|
|
10 |
drop table t1,t2; |