include/master-slave.inc
Warnings:
Note	####	Sending passwords in plain text without SSL/TLS is extremely insecure.
Note	####	Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information.
[connection master]
create database if not exists mysqltest1;
DROP VIEW IF EXISTS mysqltest1.v1;
DROP VIEW IF EXISTS mysqltest1.v2;
DROP VIEW IF EXISTS mysqltest1.v3;
DROP VIEW IF EXISTS mysqltest1.v4;
DROP TABLE IF EXISTS mysqltest1.t3;
DROP TABLE IF EXISTS mysqltest1.t1;
DROP TABLE IF EXISTS mysqltest1.t2;
DROP TABLE IF EXISTS mysqltest1.t4;
DROP TABLE IF EXISTS mysqltest1.t10;
CREATE TABLE mysqltest1.t1 (a INT, c CHAR(6),PRIMARY KEY(a));
CREATE TABLE mysqltest1.t2 (a INT, c CHAR(6),PRIMARY KEY(a));
CREATE TABLE mysqltest1.t3 (a INT, c CHAR(6), c2 CHAR(6), PRIMARY KEY(a));
CREATE TABLE mysqltest1.t4 (a INT, qty INT, price INT,PRIMARY KEY(a));
CREATE TABLE mysqltest1.t5 (qty INT, price INT, total INT, PRIMARY KEY(qty));
INSERT INTO mysqltest1.t1 VALUES (1,'Thank'),(2,'it'),(3,'Friday');
INSERT INTO mysqltest1.t2 VALUES (1,'GOD'),(2,'is'),(3,'TGIF');
INSERT INTO mysqltest1.t4 VALUES(1, 3, 50),(2, 18, 3),(4, 4, 4);
CREATE VIEW mysqltest1.v2 AS SELECT qty, price, qty*price AS value FROM mysqltest1.t4 ORDER BY qty;
CREATE VIEW mysqltest1.v1 AS SELECT t1.a, t1.c, t2.c as c2 FROM mysqltest1.t1 as t1, mysqltest1.t2 AS t2 WHERE mysqltest1.t1.a = mysqltest1.t2.a ORDER BY a;
CREATE VIEW mysqltest1.v3 AS SELECT * FROM mysqltest1.t1;
CREATE VIEW mysqltest1.v4 AS SELECT * FROM mysqltest1.v3 WHERE a > 1 WITH LOCAL CHECK OPTION;
SELECT * FROM mysqltest1.v2;
qty	price	value
3	50	150
4	4	16
18	3	54
SELECT * FROM mysqltest1.v1;
a	c	c2
1	Thank	GOD
2	it	is
3	Friday	TGIF
CREATE TABLE mysqltest1.t10 (a INT, PRIMARY KEY(a));
include/sync_slave_sql_with_master.inc
SELECT * FROM mysqltest1.v2;
qty	price	value
3	50	150
4	4	16
18	3	54
SELECT * FROM mysqltest1.v1;
a	c	c2
1	Thank	GOD
2	it	is
3	Friday	TGIF
INSERT INTO mysqltest1.t5 SELECT * FROM mysqltest1.v2;
INSERT INTO mysqltest1.t3 SELECT * FROM mysqltest1.v1;
SELECT * FROM mysqltest1.t5 ORDER BY qty;
qty	price	total
3	50	150
4	4	16
18	3	54
SELECT * FROM mysqltest1.t3 ORDER BY a;
a	c	c2
1	Thank	GOD
2	it	is
3	Friday	TGIF
include/sync_slave_sql_with_master.inc
SELECT * FROM mysqltest1.t5 ORDER BY qty;
qty	price	total
3	50	150
4	4	16
18	3	54
SELECT * FROM mysqltest1.t3 ORDER BY a;
a	c	c2
1	Thank	GOD
2	it	is
3	Friday	TGIF
INSERT INTO mysqltest1.v4 VALUES (4,'TEST');
SELECT * FROM mysqltest1.t1 ORDER BY a;
a	c
1	Thank
2	it
3	Friday
4	TEST
SELECT * FROM mysqltest1.v4 ORDER BY a;
a	c
2	it
3	Friday
4	TEST
include/sync_slave_sql_with_master.inc
SELECT * FROM mysqltest1.t1 ORDER BY a;
a	c
1	Thank
2	it
3	Friday
4	TEST
SELECT * FROM mysqltest1.v4 ORDER BY a;
a	c
2	it
3	Friday
4	TEST
DROP VIEW IF EXISTS mysqltest1.v1;
DROP VIEW IF EXISTS mysqltest1.v2;
DROP VIEW IF EXISTS mysqltest1.v3;
DROP VIEW IF EXISTS mysqltest1.v4;
DROP TABLE IF EXISTS mysqltest1.t3;
DROP TABLE IF EXISTS mysqltest1.t1;
DROP TABLE IF EXISTS mysqltest1.t2;
DROP TABLE IF EXISTS mysqltest1.t4;
DROP TABLE IF EXISTS mysqltest1.t10;
DROP DATABASE mysqltest1;
include/sync_slave_sql_with_master.inc
include/rpl_end.inc
