1
include/master-slave.inc
3
Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
4
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.
6
SET @@time_zone='+00:00';
7
SET @@timestamp=25810.123456;
18
SET @ts='2001-01-01 10:10:10.123456';
19
INSERT INTO t1 VALUES (@ts, @ts, @ts, @ts, @ts, @ts, @ts);
20
INSERT INTO t1 VALUES (NOW(), NOW(), NOW(), NOW(), NOW(), NOW(), NOW());
21
INSERT INTO t1 VALUES (NOW(6), NOW(6), NOW(6), NOW(6), NOW(6), NOW(6), NOW(6));
23
ts0 2001-01-01 10:10:10
24
ts1 2001-01-01 10:10:10.1
25
ts2 2001-01-01 10:10:10.12
26
ts3 2001-01-01 10:10:10.123
27
ts4 2001-01-01 10:10:10.1235
28
ts5 2001-01-01 10:10:10.12346
29
ts6 2001-01-01 10:10:10.123456
30
ts0 1970-01-01 07:10:10
31
ts1 1970-01-01 07:10:10.0
32
ts2 1970-01-01 07:10:10.00
33
ts3 1970-01-01 07:10:10.000
34
ts4 1970-01-01 07:10:10.0000
35
ts5 1970-01-01 07:10:10.00000
36
ts6 1970-01-01 07:10:10.000000
37
ts0 1970-01-01 07:10:10
38
ts1 1970-01-01 07:10:10.1
39
ts2 1970-01-01 07:10:10.12
40
ts3 1970-01-01 07:10:10.123
41
ts4 1970-01-01 07:10:10.1235
42
ts5 1970-01-01 07:10:10.12346
43
ts6 1970-01-01 07:10:10.123456
45
ts0 2001-01-01 13:10:10
46
ts1 2001-01-01 13:10:10.1
47
ts2 2001-01-01 13:10:10.12
48
ts3 2001-01-01 13:10:10.123
49
ts4 2001-01-01 13:10:10.1235
50
ts5 2001-01-01 13:10:10.12346
51
ts6 2001-01-01 13:10:10.123456
52
ts0 1970-01-01 10:10:10
53
ts1 1970-01-01 10:10:10.0
54
ts2 1970-01-01 10:10:10.00
55
ts3 1970-01-01 10:10:10.000
56
ts4 1970-01-01 10:10:10.0000
57
ts5 1970-01-01 10:10:10.00000
58
ts6 1970-01-01 10:10:10.000000
59
ts0 1970-01-01 10:10:10
60
ts1 1970-01-01 10:10:10.1
61
ts2 1970-01-01 10:10:10.12
62
ts3 1970-01-01 10:10:10.123
63
ts4 1970-01-01 10:10:10.1235
64
ts5 1970-01-01 10:10:10.12346
65
ts6 1970-01-01 10:10:10.123456
77
SET @ts='2001-01-01 10:10:10.123456';
78
INSERT INTO t1 VALUES (@ts, @ts, @ts, @ts, @ts, @ts, @ts);
79
INSERT INTO t1 VALUES (NOW(), NOW(), NOW(), NOW(), NOW(), NOW(), NOW());
80
INSERT INTO t1 VALUES (NOW(6), NOW(6), NOW(6), NOW(6), NOW(6), NOW(6), NOW(6));
82
dt0 2001-01-01 10:10:10
83
dt1 2001-01-01 10:10:10.1
84
dt2 2001-01-01 10:10:10.12
85
dt3 2001-01-01 10:10:10.123
86
dt4 2001-01-01 10:10:10.1235
87
dt5 2001-01-01 10:10:10.12346
88
dt6 2001-01-01 10:10:10.123456
89
dt0 1970-01-01 07:10:10
90
dt1 1970-01-01 07:10:10.0
91
dt2 1970-01-01 07:10:10.00
92
dt3 1970-01-01 07:10:10.000
93
dt4 1970-01-01 07:10:10.0000
94
dt5 1970-01-01 07:10:10.00000
95
dt6 1970-01-01 07:10:10.000000
96
dt0 1970-01-01 07:10:10
97
dt1 1970-01-01 07:10:10.1
98
dt2 1970-01-01 07:10:10.12
99
dt3 1970-01-01 07:10:10.123
100
dt4 1970-01-01 07:10:10.1235
101
dt5 1970-01-01 07:10:10.12346
102
dt6 1970-01-01 07:10:10.123456
104
dt0 2001-01-01 10:10:10
105
dt1 2001-01-01 10:10:10.1
106
dt2 2001-01-01 10:10:10.12
107
dt3 2001-01-01 10:10:10.123
108
dt4 2001-01-01 10:10:10.1235
109
dt5 2001-01-01 10:10:10.12346
110
dt6 2001-01-01 10:10:10.123456
111
dt0 1970-01-01 07:10:10
112
dt1 1970-01-01 07:10:10.0
113
dt2 1970-01-01 07:10:10.00
114
dt3 1970-01-01 07:10:10.000
115
dt4 1970-01-01 07:10:10.0000
116
dt5 1970-01-01 07:10:10.00000
117
dt6 1970-01-01 07:10:10.000000
118
dt0 1970-01-01 07:10:10
119
dt1 1970-01-01 07:10:10.1
120
dt2 1970-01-01 07:10:10.12
121
dt3 1970-01-01 07:10:10.123
122
dt4 1970-01-01 07:10:10.1235
123
dt5 1970-01-01 07:10:10.12346
124
dt6 1970-01-01 07:10:10.123456
136
SET @t='10:10:10.123456';
137
INSERT INTO t1 VALUES (@t, @t, @t, @t, @t, @t, @t);
138
INSERT INTO t1 VALUES (CURTIME(), CURTIME(), CURTIME(), CURTIME(), CURTIME(), CURTIME(), CURTIME());
139
INSERT INTO t1 VALUES (CURTIME(6), CURTIME(6), CURTIME(6), CURTIME(6), CURTIME(6), CURTIME(6), CURTIME(6));