2
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
5
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
7
drop database if exists mysqltest1;
8
create database mysqltest1;
10
CREATE TABLE t1 (a char(3));
11
CREATE TABLE t2 (a char(3));
12
insert into t1 values("ANN");
13
insert into t1 values("GUI");
14
insert into t2 values("LIL");
15
insert into t2 values("ABE");
16
insert into t2 values("ANG");
18
select * from t1 order by a;
22
select * from t2 order by a;
27
DROP DATABASE mysqltest1;