include/master-slave.inc
[connection master]
drop database if exists mysqltest1;
create database mysqltest1;
use mysqltest1;
CREATE TABLE t1 (a char(3));
CREATE TABLE t2 (a char(3));
insert into t1 values("ANN");
insert into t1 values("GUI");
insert into t2 values("LIL");
insert into t2 values("ABE");
insert into t2 values("ANG");
use mysqltest1;
select * from t1 order by a;
a
ANN
GUI
select * from t2 order by a;
a
ABE
ANG
LIL
DROP DATABASE mysqltest1;
include/rpl_end.inc