1include/master-slave.inc 2[connection master] 3connection master; 4SELECT @@global.mysql56_temporal_format AS on_master; 5on_master 61 7connection slave; 8SELECT @@global.mysql56_temporal_format AS on_slave; 9on_slave 101 11connection master; 12CREATE TABLE t1 13( 14c0 TIME(0), 15c1 TIME(1), 16c2 TIME(2), 17c3 TIME(3), 18c4 TIME(4), 19c5 TIME(5), 20c6 TIME(6) 21); 22CREATE TABLE t2 23( 24c0 TIMESTAMP(0), 25c1 TIMESTAMP(1), 26c2 TIMESTAMP(2), 27c3 TIMESTAMP(3), 28c4 TIMESTAMP(4), 29c5 TIMESTAMP(5), 30c6 TIMESTAMP(6) 31); 32CREATE TABLE t3 33( 34c0 DATETIME(0), 35c1 DATETIME(1), 36c2 DATETIME(2), 37c3 DATETIME(3), 38c4 DATETIME(4), 39c5 DATETIME(5), 40c6 DATETIME(6) 41); 42INSERT INTO t1 VALUES ('01:01:01','01:01:01.1','01:01:01.11','01:01:01.111','01:01:01.1111','01:01:01.11111','01:01:01.111111'); 43INSERT INTO t2 VALUES ('2001-01-01 01:01:01','2001-01-01 01:01:01.1','2001-01-01 01:01:01.11','2001-01-01 01:01:01.111','2001-01-01 01:01:01.1111','2001-01-01 01:01:01.11111','2001-01-01 01:01:01.111111'); 44INSERT INTO t3 VALUES ('2001-01-01 01:01:01','2001-01-01 01:01:01.1','2001-01-01 01:01:01.11','2001-01-01 01:01:01.111','2001-01-01 01:01:01.1111','2001-01-01 01:01:01.11111','2001-01-01 01:01:01.111111'); 45SELECT TABLE_NAME, TABLE_ROWS, AVG_ROW_LENGTH,DATA_LENGTH FROM INFORMATION_SCHEMA.TABLES 46WHERE TABLE_NAME RLIKE 't[1-3]' ORDER BY TABLE_NAME; 47TABLE_NAME TABLE_ROWS AVG_ROW_LENGTH DATA_LENGTH 48t1 1 34 34 49t2 1 41 41 50t3 1 48 48 51connection slave; 52connection slave; 53SELECT * FROM t1;; 54c0 01:01:01 55c1 01:01:01.1 56c2 01:01:01.11 57c3 01:01:01.111 58c4 01:01:01.1111 59c5 01:01:01.11111 60c6 01:01:01.111111 61SELECT * FROM t2;; 62c0 2001-01-01 01:01:01 63c1 2001-01-01 01:01:01.1 64c2 2001-01-01 01:01:01.11 65c3 2001-01-01 01:01:01.111 66c4 2001-01-01 01:01:01.1111 67c5 2001-01-01 01:01:01.11111 68c6 2001-01-01 01:01:01.111111 69SELECT * FROM t3;; 70c0 2001-01-01 01:01:01 71c1 2001-01-01 01:01:01.1 72c2 2001-01-01 01:01:01.11 73c3 2001-01-01 01:01:01.111 74c4 2001-01-01 01:01:01.1111 75c5 2001-01-01 01:01:01.11111 76c6 2001-01-01 01:01:01.111111 77SELECT TABLE_NAME, TABLE_ROWS, AVG_ROW_LENGTH,DATA_LENGTH FROM INFORMATION_SCHEMA.TABLES 78WHERE TABLE_NAME RLIKE 't[1-3]' ORDER BY TABLE_NAME; 79TABLE_NAME TABLE_ROWS AVG_ROW_LENGTH DATA_LENGTH 80t1 1 34 34 81t2 1 41 41 82t3 1 48 48 83connection master; 84DROP TABLE t1; 85DROP TABLE t2; 86DROP TABLE t3; 87connection slave; 88SET @@global.mysql56_temporal_format=DEFAULT; 89connection master; 90SET @@global.mysql56_temporal_format=DEFAULT; 91include/rpl_end.inc 92