1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
|
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 connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
[connection master]
SET @@time_zone='+00:00';
SET @@timestamp=25810.123456;
SET sql_mode = 'NO_ENGINE_SUBSTITUTION';
CREATE TABLE t1
(
ts0 TIMESTAMP(0),
ts1 TIMESTAMP(1),
ts2 TIMESTAMP(2),
ts3 TIMESTAMP(3),
ts4 TIMESTAMP(4),
ts5 TIMESTAMP(5),
ts6 TIMESTAMP(6)
);
SET sql_mode = default;
SET @ts='2001-01-01 10:10:10.123456';
INSERT INTO t1 VALUES (@ts, @ts, @ts, @ts, @ts, @ts, @ts);
INSERT INTO t1 VALUES (NOW(), NOW(), NOW(), NOW(), NOW(), NOW(), NOW());
INSERT INTO t1 VALUES (NOW(6), NOW(6), NOW(6), NOW(6), NOW(6), NOW(6), NOW(6));
SELECT * FROM t1;
ts0 2001-01-01 10:10:10
ts1 2001-01-01 10:10:10.1
ts2 2001-01-01 10:10:10.12
ts3 2001-01-01 10:10:10.123
ts4 2001-01-01 10:10:10.1235
ts5 2001-01-01 10:10:10.12346
ts6 2001-01-01 10:10:10.123456
ts0 1970-01-01 07:10:10
ts1 1970-01-01 07:10:10.0
ts2 1970-01-01 07:10:10.00
ts3 1970-01-01 07:10:10.000
ts4 1970-01-01 07:10:10.0000
ts5 1970-01-01 07:10:10.00000
ts6 1970-01-01 07:10:10.000000
ts0 1970-01-01 07:10:10
ts1 1970-01-01 07:10:10.1
ts2 1970-01-01 07:10:10.12
ts3 1970-01-01 07:10:10.123
ts4 1970-01-01 07:10:10.1235
ts5 1970-01-01 07:10:10.12346
ts6 1970-01-01 07:10:10.123456
include/sync_slave_sql_with_master.inc
SELECT * FROM t1;
ts0 2001-01-01 13:10:10
ts1 2001-01-01 13:10:10.1
ts2 2001-01-01 13:10:10.12
ts3 2001-01-01 13:10:10.123
ts4 2001-01-01 13:10:10.1235
ts5 2001-01-01 13:10:10.12346
ts6 2001-01-01 13:10:10.123456
ts0 1970-01-01 10:10:10
ts1 1970-01-01 10:10:10.0
ts2 1970-01-01 10:10:10.00
ts3 1970-01-01 10:10:10.000
ts4 1970-01-01 10:10:10.0000
ts5 1970-01-01 10:10:10.00000
ts6 1970-01-01 10:10:10.000000
ts0 1970-01-01 10:10:10
ts1 1970-01-01 10:10:10.1
ts2 1970-01-01 10:10:10.12
ts3 1970-01-01 10:10:10.123
ts4 1970-01-01 10:10:10.1235
ts5 1970-01-01 10:10:10.12346
ts6 1970-01-01 10:10:10.123456
DROP TABLE t1;
include/sync_slave_sql_with_master.inc
CREATE TABLE t1
(
dt0 DATETIME(0),
dt1 DATETIME(1),
dt2 DATETIME(2),
dt3 DATETIME(3),
dt4 DATETIME(4),
dt5 DATETIME(5),
dt6 DATETIME(6)
);
SET @ts='2001-01-01 10:10:10.123456';
INSERT INTO t1 VALUES (@ts, @ts, @ts, @ts, @ts, @ts, @ts);
INSERT INTO t1 VALUES (NOW(), NOW(), NOW(), NOW(), NOW(), NOW(), NOW());
INSERT INTO t1 VALUES (NOW(6), NOW(6), NOW(6), NOW(6), NOW(6), NOW(6), NOW(6));
SELECT * FROM t1;
dt0 2001-01-01 10:10:10
dt1 2001-01-01 10:10:10.1
dt2 2001-01-01 10:10:10.12
dt3 2001-01-01 10:10:10.123
dt4 2001-01-01 10:10:10.1235
dt5 2001-01-01 10:10:10.12346
dt6 2001-01-01 10:10:10.123456
dt0 1970-01-01 07:10:10
dt1 1970-01-01 07:10:10.0
dt2 1970-01-01 07:10:10.00
dt3 1970-01-01 07:10:10.000
dt4 1970-01-01 07:10:10.0000
dt5 1970-01-01 07:10:10.00000
dt6 1970-01-01 07:10:10.000000
dt0 1970-01-01 07:10:10
dt1 1970-01-01 07:10:10.1
dt2 1970-01-01 07:10:10.12
dt3 1970-01-01 07:10:10.123
dt4 1970-01-01 07:10:10.1235
dt5 1970-01-01 07:10:10.12346
dt6 1970-01-01 07:10:10.123456
include/sync_slave_sql_with_master.inc
SELECT * FROM t1;
dt0 2001-01-01 10:10:10
dt1 2001-01-01 10:10:10.1
dt2 2001-01-01 10:10:10.12
dt3 2001-01-01 10:10:10.123
dt4 2001-01-01 10:10:10.1235
dt5 2001-01-01 10:10:10.12346
dt6 2001-01-01 10:10:10.123456
dt0 1970-01-01 07:10:10
dt1 1970-01-01 07:10:10.0
dt2 1970-01-01 07:10:10.00
dt3 1970-01-01 07:10:10.000
dt4 1970-01-01 07:10:10.0000
dt5 1970-01-01 07:10:10.00000
dt6 1970-01-01 07:10:10.000000
dt0 1970-01-01 07:10:10
dt1 1970-01-01 07:10:10.1
dt2 1970-01-01 07:10:10.12
dt3 1970-01-01 07:10:10.123
dt4 1970-01-01 07:10:10.1235
dt5 1970-01-01 07:10:10.12346
dt6 1970-01-01 07:10:10.123456
DROP TABLE t1;
include/sync_slave_sql_with_master.inc
CREATE TABLE t1
(
t0 TIME(0),
t1 TIME(1),
t2 TIME(2),
t3 TIME(3),
t4 TIME(4),
t5 TIME(5),
t6 TIME(6)
);
SET @t='10:10:10.123456';
INSERT INTO t1 VALUES (@t, @t, @t, @t, @t, @t, @t);
INSERT INTO t1 VALUES (CURTIME(), CURTIME(), CURTIME(), CURTIME(), CURTIME(), CURTIME(), CURTIME());
INSERT INTO t1 VALUES (CURTIME(6), CURTIME(6), CURTIME(6), CURTIME(6), CURTIME(6), CURTIME(6), CURTIME(6));
SELECT * FROM t1;
t0 10:10:10
t1 10:10:10.1
t2 10:10:10.12
t3 10:10:10.123
t4 10:10:10.1235
t5 10:10:10.12346
t6 10:10:10.123456
t0 07:10:10
t1 07:10:10.0
t2 07:10:10.00
t3 07:10:10.000
t4 07:10:10.0000
t5 07:10:10.00000
t6 07:10:10.000000
t0 07:10:10
t1 07:10:10.1
t2 07:10:10.12
t3 07:10:10.123
t4 07:10:10.1235
t5 07:10:10.12346
t6 07:10:10.123456
include/sync_slave_sql_with_master.inc
SELECT * FROM t1;
t0 10:10:10
t1 10:10:10.1
t2 10:10:10.12
t3 10:10:10.123
t4 10:10:10.1235
t5 10:10:10.12346
t6 10:10:10.123456
t0 07:10:10
t1 07:10:10.0
t2 07:10:10.00
t3 07:10:10.000
t4 07:10:10.0000
t5 07:10:10.00000
t6 07:10:10.000000
t0 07:10:10
t1 07:10:10.1
t2 07:10:10.12
t3 07:10:10.123
t4 07:10:10.1235
t5 07:10:10.12346
t6 07:10:10.123456
DROP TABLE t1;
include/sync_slave_sql_with_master.inc
include/rpl_end.inc
|
