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
CREATE TABLE t1 (a INT NOT NULL PRIMARY KEY AUTO_INCREMENT, b INT,
9
INSERT INTO t1(b) VALUES(1),(1),(2) ON DUPLICATE KEY UPDATE t1.b=10;
20
Master_Log_File master-bin.000001
24
Relay_Master_Log_File master-bin.000001
30
Replicate_Ignore_Table
31
Replicate_Wild_Do_Table
32
Replicate_Wild_Ignore_Table
34
Last_Error Error 'master may suffer from http://bugs.mysql.com/bug.php?id=24432 so slave stops; check error log on slave for more info' on query. Default database: 'test'. Query: 'INSERT INTO t1(b) VALUES(1),(1),(2) ON DUPLICATE KEY UPDATE t1.b=10'
36
Exec_Master_Log_Pos 238
47
Seconds_Behind_Master #
56
id bigint(20) unsigned NOT NULL auto_increment,
57
field_1 int(10) unsigned NOT NULL,
58
field_2 varchar(255) NOT NULL,
59
field_3 varchar(255) NOT NULL,
61
UNIQUE KEY field_1 (field_1, field_2)
64
field_a int(10) unsigned NOT NULL,
65
field_b varchar(255) NOT NULL,
66
field_c varchar(255) NOT NULL
68
INSERT INTO t2 (field_a, field_b, field_c) VALUES (1, 'a', '1a');
69
INSERT INTO t2 (field_a, field_b, field_c) VALUES (2, 'b', '2b');
70
INSERT INTO t2 (field_a, field_b, field_c) VALUES (3, 'c', '3c');
71
INSERT INTO t2 (field_a, field_b, field_c) VALUES (4, 'd', '4d');
72
INSERT INTO t2 (field_a, field_b, field_c) VALUES (5, 'e', '5e');
73
INSERT INTO t1 (field_1, field_2, field_3)
74
SELECT t2.field_a, t2.field_b, t2.field_c
76
ON DUPLICATE KEY UPDATE
77
t1.field_3 = t2.field_c;
78
INSERT INTO t2 (field_a, field_b, field_c) VALUES (6, 'f', '6f');
79
INSERT INTO t1 (field_1, field_2, field_3)
80
SELECT t2.field_a, t2.field_b, t2.field_c
82
ON DUPLICATE KEY UPDATE
83
t1.field_3 = t2.field_c;
85
id field_1 field_2 field_3
98
Master_Log_File master-bin.000001
102
Relay_Master_Log_File master-bin.000001
108
Replicate_Ignore_Table
109
Replicate_Wild_Do_Table
110
Replicate_Wild_Ignore_Table
112
Last_Error Error 'master may suffer from http://bugs.mysql.com/bug.php?id=24432 so slave stops; check error log on slave for more info' on query. Default database: 'test'. Query: 'INSERT INTO t1 (field_1, field_2, field_3)
113
SELECT t2.field_a, t2.field_b, t2.field_c
115
ON DUPLICATE KEY UPDATE
116
t1.field_3 = t2.field_c'
118
Exec_Master_Log_Pos 1270
123
Master_SSL_Allowed No
129
Seconds_Behind_Master #
131
id field_1 field_2 field_3