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;
8 DROP DATABASE IF EXISTS federated;
9 CREATE DATABASE federated;
10 DROP DATABASE IF EXISTS federated;
11 CREATE DATABASE federated;
12 DROP TABLE IF EXISTS federated.t1;
14 Note 1051 Unknown table 't1'
15 CREATE TABLE federated.t1 (
16 `id` int(20) NOT NULL,
17 `name` varchar(32) NOT NULL default ''
19 DEFAULT CHARSET=latin1 ENGINE=innodb;
20 DROP TABLE IF EXISTS federated.t1;
22 Note 1051 Unknown table 't1'
23 CREATE TABLE federated.t1 (
24 `id` int(20) NOT NULL,
25 `name` varchar(32) NOT NULL default ''
27 ENGINE="FEDERATED" DEFAULT CHARSET=latin1
28 CONNECTION='mysql://root@127.0.0.1:SLAVE_PORT/federated/t1';
30 INSERT INTO federated.t1 (id, name) VALUES (1, 'foo');
31 INSERT INTO federated.t1 (id, name) VALUES (2, 'fee');
33 INSERT INTO federated.t1 (id, name) VALUES (3, 'fie');
34 INSERT INTO federated.t1 (id, name) VALUES (4, 'fum');
37 INSERT INTO federated.t1 (id, name) VALUES (5, 'foe');
38 INSERT INTO federated.t1 (id, name) VALUES (6, 'fig');
39 SELECT * FROM federated.t1;
45 DELETE FROM federated.t1;
46 DROP TABLE IF EXISTS federated.t1;
47 DROP DATABASE IF EXISTS federated;
48 DROP TABLE IF EXISTS federated.t1;
49 DROP DATABASE IF EXISTS federated;