| 1 |
include/master-slave.inc |
| 2 |
Warnings: |
| 3 |
Note #### Sending passwords in plain text without SSL/TLS is extremely insecure. |
| 4 |
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. |
| 5 |
[connection master] |
| 6 |
drop table if exists t1; |
| 7 |
CREATE TABLE t1 (id MEDIUMINT NOT NULL, b1 BIT(8), vc |
| 8 |
VARCHAR(255), bc CHAR(255), d DECIMAL(10,4) DEFAULT 0, f FLOAT DEFAULT |
| 9 |
0, total BIGINT UNSIGNED, y YEAR, t TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP |
| 10 |
ON UPDATE CURRENT_TIMESTAMP,PRIMARY KEY(id)); |
| 11 |
include/sync_slave_sql_with_master.inc |
| 12 |
alter table t1 engine=myisam; |
| 13 |
show create table t1; |
| 14 |
Table Create Table |
| 15 |
t1 CREATE TABLE `t1` ( |
| 16 |
`id` mediumint NOT NULL, |
| 17 |
`b1` bit(8) DEFAULT NULL, |
| 18 |
`vc` varchar(255) DEFAULT NULL, |
| 19 |
`bc` char(255) DEFAULT NULL, |
| 20 |
`d` decimal(10,4) DEFAULT '0.0000', |
| 21 |
`f` float DEFAULT '0', |
| 22 |
`total` bigint unsigned DEFAULT NULL, |
| 23 |
`y` year DEFAULT NULL, |
| 24 |
`t` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, |
| 25 |
PRIMARY KEY (`id`) |
| 26 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci |
| 27 |
include/sync_slave_sql_with_master.inc |
| 28 |
alter table t1 engine=myisam; |
| 29 |
show create table t1; |
| 30 |
Table Create Table |
| 31 |
t1 CREATE TABLE `t1` ( |
| 32 |
`id` mediumint NOT NULL, |
| 33 |
`b1` bit(8) DEFAULT NULL, |
| 34 |
`vc` varchar(255) DEFAULT NULL, |
| 35 |
`bc` char(255) DEFAULT NULL, |
| 36 |
`d` decimal(10,4) DEFAULT '0.0000', |
| 37 |
`f` float DEFAULT '0', |
| 38 |
`total` bigint unsigned DEFAULT NULL, |
| 39 |
`y` year DEFAULT NULL, |
| 40 |
`t` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, |
| 41 |
PRIMARY KEY (`id`) |
| 42 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci |
| 43 |
INSERT INTO t1 VALUES(42,1,'Testing MySQL databases is a cool ', 'Must make it bug free for the customer',654321.4321,15.21,0,1965,"2005-11-14"); |
| 44 |
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id; |
| 45 |
id hex(b1) vc bc d f total y t |
| 46 |
42 1 Testing MySQL databases is a cool Must make it bug free for the customer 654321.4321 15.21 0 1965 2005-11-14 00:00:00 |
| 47 |
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id; |
| 48 |
id hex(b1) vc bc d f total y t |
| 49 |
42 1 Testing MySQL databases is a cool Must make it bug free for the customer 654321.4321 15.21 0 1965 2005-11-14 00:00:00 |
| 50 |
UPDATE t1 SET b1 = 0, t="2005-09-09" WHERE b1 = 1; |
| 51 |
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id; |
| 52 |
id hex(b1) vc bc d f total y t |
| 53 |
42 0 Testing MySQL databases is a cool Must make it bug free for the customer 654321.4321 15.21 0 1965 2005-09-09 00:00:00 |
| 54 |
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id; |
| 55 |
id hex(b1) vc bc d f total y t |
| 56 |
42 0 Testing MySQL databases is a cool Must make it bug free for the customer 654321.4321 15.21 0 1965 2005-09-09 00:00:00 |
| 57 |
DELETE FROM t1 WHERE id = 42; |
| 58 |
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id; |
| 59 |
id hex(b1) vc bc d f total y t |
| 60 |
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id; |
| 61 |
id hex(b1) vc bc d f total y t |
| 62 |
alter table t1 engine=innodb; |
| 63 |
show create table t1; |
| 64 |
Table Create Table |
| 65 |
t1 CREATE TABLE `t1` ( |
| 66 |
`id` mediumint NOT NULL, |
| 67 |
`b1` bit(8) DEFAULT NULL, |
| 68 |
`vc` varchar(255) DEFAULT NULL, |
| 69 |
`bc` char(255) DEFAULT NULL, |
| 70 |
`d` decimal(10,4) DEFAULT '0.0000', |
| 71 |
`f` float DEFAULT '0', |
| 72 |
`total` bigint unsigned DEFAULT NULL, |
| 73 |
`y` year DEFAULT NULL, |
| 74 |
`t` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, |
| 75 |
PRIMARY KEY (`id`) |
| 76 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci |
| 77 |
INSERT INTO t1 VALUES(42,1,'Testing MySQL databases is a cool ', 'Must make it bug free for the customer',654321.4321,15.21,0,1965,"2005-11-14"); |
| 78 |
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id; |
| 79 |
id hex(b1) vc bc d f total y t |
| 80 |
42 1 Testing MySQL databases is a cool Must make it bug free for the customer 654321.4321 15.21 0 1965 2005-11-14 00:00:00 |
| 81 |
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id; |
| 82 |
id hex(b1) vc bc d f total y t |
| 83 |
42 1 Testing MySQL databases is a cool Must make it bug free for the customer 654321.4321 15.21 0 1965 2005-11-14 00:00:00 |
| 84 |
UPDATE t1 SET b1 = 0, t="2005-09-09" WHERE b1 = 1; |
| 85 |
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id; |
| 86 |
id hex(b1) vc bc d f total y t |
| 87 |
42 0 Testing MySQL databases is a cool Must make it bug free for the customer 654321.4321 15.21 0 1965 2005-09-09 00:00:00 |
| 88 |
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id; |
| 89 |
id hex(b1) vc bc d f total y t |
| 90 |
42 0 Testing MySQL databases is a cool Must make it bug free for the customer 654321.4321 15.21 0 1965 2005-09-09 00:00:00 |
| 91 |
DELETE FROM t1 WHERE id = 42; |
| 92 |
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id; |
| 93 |
id hex(b1) vc bc d f total y t |
| 94 |
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id; |
| 95 |
id hex(b1) vc bc d f total y t |
| 96 |
alter table t1 engine=memory; |
| 97 |
show create table t1; |
| 98 |
Table Create Table |
| 99 |
t1 CREATE TABLE `t1` ( |
| 100 |
`id` mediumint NOT NULL, |
| 101 |
`b1` bit(8) DEFAULT NULL, |
| 102 |
`vc` varchar(255) DEFAULT NULL, |
| 103 |
`bc` char(255) DEFAULT NULL, |
| 104 |
`d` decimal(10,4) DEFAULT '0.0000', |
| 105 |
`f` float DEFAULT '0', |
| 106 |
`total` bigint unsigned DEFAULT NULL, |
| 107 |
`y` year DEFAULT NULL, |
| 108 |
`t` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, |
| 109 |
PRIMARY KEY (`id`) |
| 110 |
) ENGINE=MEMORY DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci |
| 111 |
INSERT INTO t1 VALUES(42,1,'Testing MySQL databases is a cool ', 'Must make it bug free for the customer',654321.4321,15.21,0,1965,"2005-11-14"); |
| 112 |
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id; |
| 113 |
id hex(b1) vc bc d f total y t |
| 114 |
42 1 Testing MySQL databases is a cool Must make it bug free for the customer 654321.4321 15.21 0 1965 2005-11-14 00:00:00 |
| 115 |
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id; |
| 116 |
id hex(b1) vc bc d f total y t |
| 117 |
42 1 Testing MySQL databases is a cool Must make it bug free for the customer 654321.4321 15.21 0 1965 2005-11-14 00:00:00 |
| 118 |
UPDATE t1 SET b1 = 0, t="2005-09-09" WHERE b1 = 1; |
| 119 |
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id; |
| 120 |
id hex(b1) vc bc d f total y t |
| 121 |
42 0 Testing MySQL databases is a cool Must make it bug free for the customer 654321.4321 15.21 0 1965 2005-09-09 00:00:00 |
| 122 |
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id; |
| 123 |
id hex(b1) vc bc d f total y t |
| 124 |
42 0 Testing MySQL databases is a cool Must make it bug free for the customer 654321.4321 15.21 0 1965 2005-09-09 00:00:00 |
| 125 |
DELETE FROM t1 WHERE id = 42; |
| 126 |
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id; |
| 127 |
id hex(b1) vc bc d f total y t |
| 128 |
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id; |
| 129 |
id hex(b1) vc bc d f total y t |
| 130 |
alter table t1 engine=memory; |
| 131 |
show create table t1; |
| 132 |
Table Create Table |
| 133 |
t1 CREATE TABLE `t1` ( |
| 134 |
`id` mediumint NOT NULL, |
| 135 |
`b1` bit(8) DEFAULT NULL, |
| 136 |
`vc` varchar(255) DEFAULT NULL, |
| 137 |
`bc` char(255) DEFAULT NULL, |
| 138 |
`d` decimal(10,4) DEFAULT '0.0000', |
| 139 |
`f` float DEFAULT '0', |
| 140 |
`total` bigint unsigned DEFAULT NULL, |
| 141 |
`y` year DEFAULT NULL, |
| 142 |
`t` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, |
| 143 |
PRIMARY KEY (`id`) |
| 144 |
) ENGINE=MEMORY DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci |
| 145 |
include/sync_slave_sql_with_master.inc |
| 146 |
alter table t1 engine=myisam; |
| 147 |
show create table t1; |
| 148 |
Table Create Table |
| 149 |
t1 CREATE TABLE `t1` ( |
| 150 |
`id` mediumint NOT NULL, |
| 151 |
`b1` bit(8) DEFAULT NULL, |
| 152 |
`vc` varchar(255) DEFAULT NULL, |
| 153 |
`bc` char(255) DEFAULT NULL, |
| 154 |
`d` decimal(10,4) DEFAULT '0.0000', |
| 155 |
`f` float DEFAULT '0', |
| 156 |
`total` bigint unsigned DEFAULT NULL, |
| 157 |
`y` year DEFAULT NULL, |
| 158 |
`t` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, |
| 159 |
PRIMARY KEY (`id`) |
| 160 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci |
| 161 |
INSERT INTO t1 VALUES(42,1,'Testing MySQL databases is a cool ', 'Must make it bug free for the customer',654321.4321,15.21,0,1965,"2005-11-14"); |
| 162 |
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id; |
| 163 |
id hex(b1) vc bc d f total y t |
| 164 |
42 1 Testing MySQL databases is a cool Must make it bug free for the customer 654321.4321 15.21 0 1965 2005-11-14 00:00:00 |
| 165 |
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id; |
| 166 |
id hex(b1) vc bc d f total y t |
| 167 |
42 1 Testing MySQL databases is a cool Must make it bug free for the customer 654321.4321 15.21 0 1965 2005-11-14 00:00:00 |
| 168 |
UPDATE t1 SET b1 = 0, t="2005-09-09" WHERE b1 = 1; |
| 169 |
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id; |
| 170 |
id hex(b1) vc bc d f total y t |
| 171 |
42 0 Testing MySQL databases is a cool Must make it bug free for the customer 654321.4321 15.21 0 1965 2005-09-09 00:00:00 |
| 172 |
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id; |
| 173 |
id hex(b1) vc bc d f total y t |
| 174 |
42 0 Testing MySQL databases is a cool Must make it bug free for the customer 654321.4321 15.21 0 1965 2005-09-09 00:00:00 |
| 175 |
DELETE FROM t1 WHERE id = 42; |
| 176 |
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id; |
| 177 |
id hex(b1) vc bc d f total y t |
| 178 |
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id; |
| 179 |
id hex(b1) vc bc d f total y t |
| 180 |
alter table t1 engine=innodb; |
| 181 |
show create table t1; |
| 182 |
Table Create Table |
| 183 |
t1 CREATE TABLE `t1` ( |
| 184 |
`id` mediumint NOT NULL, |
| 185 |
`b1` bit(8) DEFAULT NULL, |
| 186 |
`vc` varchar(255) DEFAULT NULL, |
| 187 |
`bc` char(255) DEFAULT NULL, |
| 188 |
`d` decimal(10,4) DEFAULT '0.0000', |
| 189 |
`f` float DEFAULT '0', |
| 190 |
`total` bigint unsigned DEFAULT NULL, |
| 191 |
`y` year DEFAULT NULL, |
| 192 |
`t` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, |
| 193 |
PRIMARY KEY (`id`) |
| 194 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci |
| 195 |
INSERT INTO t1 VALUES(42,1,'Testing MySQL databases is a cool ', 'Must make it bug free for the customer',654321.4321,15.21,0,1965,"2005-11-14"); |
| 196 |
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id; |
| 197 |
id hex(b1) vc bc d f total y t |
| 198 |
42 1 Testing MySQL databases is a cool Must make it bug free for the customer 654321.4321 15.21 0 1965 2005-11-14 00:00:00 |
| 199 |
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id; |
| 200 |
id hex(b1) vc bc d f total y t |
| 201 |
42 1 Testing MySQL databases is a cool Must make it bug free for the customer 654321.4321 15.21 0 1965 2005-11-14 00:00:00 |
| 202 |
UPDATE t1 SET b1 = 0, t="2005-09-09" WHERE b1 = 1; |
| 203 |
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id; |
| 204 |
id hex(b1) vc bc d f total y t |
| 205 |
42 0 Testing MySQL databases is a cool Must make it bug free for the customer 654321.4321 15.21 0 1965 2005-09-09 00:00:00 |
| 206 |
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id; |
| 207 |
id hex(b1) vc bc d f total y t |
| 208 |
42 0 Testing MySQL databases is a cool Must make it bug free for the customer 654321.4321 15.21 0 1965 2005-09-09 00:00:00 |
| 209 |
DELETE FROM t1 WHERE id = 42; |
| 210 |
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id; |
| 211 |
id hex(b1) vc bc d f total y t |
| 212 |
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id; |
| 213 |
id hex(b1) vc bc d f total y t |
| 214 |
alter table t1 engine=memory; |
| 215 |
show create table t1; |
| 216 |
Table Create Table |
| 217 |
t1 CREATE TABLE `t1` ( |
| 218 |
`id` mediumint NOT NULL, |
| 219 |
`b1` bit(8) DEFAULT NULL, |
| 220 |
`vc` varchar(255) DEFAULT NULL, |
| 221 |
`bc` char(255) DEFAULT NULL, |
| 222 |
`d` decimal(10,4) DEFAULT '0.0000', |
| 223 |
`f` float DEFAULT '0', |
| 224 |
`total` bigint unsigned DEFAULT NULL, |
| 225 |
`y` year DEFAULT NULL, |
| 226 |
`t` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, |
| 227 |
PRIMARY KEY (`id`) |
| 228 |
) ENGINE=MEMORY DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci |
| 229 |
INSERT INTO t1 VALUES(42,1,'Testing MySQL databases is a cool ', 'Must make it bug free for the customer',654321.4321,15.21,0,1965,"2005-11-14"); |
| 230 |
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id; |
| 231 |
id hex(b1) vc bc d f total y t |
| 232 |
42 1 Testing MySQL databases is a cool Must make it bug free for the customer 654321.4321 15.21 0 1965 2005-11-14 00:00:00 |
| 233 |
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id; |
| 234 |
id hex(b1) vc bc d f total y t |
| 235 |
42 1 Testing MySQL databases is a cool Must make it bug free for the customer 654321.4321 15.21 0 1965 2005-11-14 00:00:00 |
| 236 |
UPDATE t1 SET b1 = 0, t="2005-09-09" WHERE b1 = 1; |
| 237 |
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id; |
| 238 |
id hex(b1) vc bc d f total y t |
| 239 |
42 0 Testing MySQL databases is a cool Must make it bug free for the customer 654321.4321 15.21 0 1965 2005-09-09 00:00:00 |
| 240 |
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id; |
| 241 |
id hex(b1) vc bc d f total y t |
| 242 |
42 0 Testing MySQL databases is a cool Must make it bug free for the customer 654321.4321 15.21 0 1965 2005-09-09 00:00:00 |
| 243 |
DELETE FROM t1 WHERE id = 42; |
| 244 |
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id; |
| 245 |
id hex(b1) vc bc d f total y t |
| 246 |
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id; |
| 247 |
id hex(b1) vc bc d f total y t |
| 248 |
alter table t1 engine=innodb; |
| 249 |
show create table t1; |
| 250 |
Table Create Table |
| 251 |
t1 CREATE TABLE `t1` ( |
| 252 |
`id` mediumint NOT NULL, |
| 253 |
`b1` bit(8) DEFAULT NULL, |
| 254 |
`vc` varchar(255) DEFAULT NULL, |
| 255 |
`bc` char(255) DEFAULT NULL, |
| 256 |
`d` decimal(10,4) DEFAULT '0.0000', |
| 257 |
`f` float DEFAULT '0', |
| 258 |
`total` bigint unsigned DEFAULT NULL, |
| 259 |
`y` year DEFAULT NULL, |
| 260 |
`t` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, |
| 261 |
PRIMARY KEY (`id`) |
| 262 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci |
| 263 |
include/sync_slave_sql_with_master.inc |
| 264 |
alter table t1 engine=myisam; |
| 265 |
show create table t1; |
| 266 |
Table Create Table |
| 267 |
t1 CREATE TABLE `t1` ( |
| 268 |
`id` mediumint NOT NULL, |
| 269 |
`b1` bit(8) DEFAULT NULL, |
| 270 |
`vc` varchar(255) DEFAULT NULL, |
| 271 |
`bc` char(255) DEFAULT NULL, |
| 272 |
`d` decimal(10,4) DEFAULT '0.0000', |
| 273 |
`f` float DEFAULT '0', |
| 274 |
`total` bigint unsigned DEFAULT NULL, |
| 275 |
`y` year DEFAULT NULL, |
| 276 |
`t` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, |
| 277 |
PRIMARY KEY (`id`) |
| 278 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci |
| 279 |
INSERT INTO t1 VALUES(42,1,'Testing MySQL databases is a cool ', 'Must make it bug free for the customer',654321.4321,15.21,0,1965,"2005-11-14"); |
| 280 |
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id; |
| 281 |
id hex(b1) vc bc d f total y t |
| 282 |
42 1 Testing MySQL databases is a cool Must make it bug free for the customer 654321.4321 15.21 0 1965 2005-11-14 00:00:00 |
| 283 |
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id; |
| 284 |
id hex(b1) vc bc d f total y t |
| 285 |
42 1 Testing MySQL databases is a cool Must make it bug free for the customer 654321.4321 15.21 0 1965 2005-11-14 00:00:00 |
| 286 |
UPDATE t1 SET b1 = 0, t="2005-09-09" WHERE b1 = 1; |
| 287 |
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id; |
| 288 |
id hex(b1) vc bc d f total y t |
| 289 |
42 0 Testing MySQL databases is a cool Must make it bug free for the customer 654321.4321 15.21 0 1965 2005-09-09 00:00:00 |
| 290 |
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id; |
| 291 |
id hex(b1) vc bc d f total y t |
| 292 |
42 0 Testing MySQL databases is a cool Must make it bug free for the customer 654321.4321 15.21 0 1965 2005-09-09 00:00:00 |
| 293 |
DELETE FROM t1 WHERE id = 42; |
| 294 |
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id; |
| 295 |
id hex(b1) vc bc d f total y t |
| 296 |
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id; |
| 297 |
id hex(b1) vc bc d f total y t |
| 298 |
alter table t1 engine=innodb; |
| 299 |
show create table t1; |
| 300 |
Table Create Table |
| 301 |
t1 CREATE TABLE `t1` ( |
| 302 |
`id` mediumint NOT NULL, |
| 303 |
`b1` bit(8) DEFAULT NULL, |
| 304 |
`vc` varchar(255) DEFAULT NULL, |
| 305 |
`bc` char(255) DEFAULT NULL, |
| 306 |
`d` decimal(10,4) DEFAULT '0.0000', |
| 307 |
`f` float DEFAULT '0', |
| 308 |
`total` bigint unsigned DEFAULT NULL, |
| 309 |
`y` year DEFAULT NULL, |
| 310 |
`t` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, |
| 311 |
PRIMARY KEY (`id`) |
| 312 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci |
| 313 |
INSERT INTO t1 VALUES(42,1,'Testing MySQL databases is a cool ', 'Must make it bug free for the customer',654321.4321,15.21,0,1965,"2005-11-14"); |
| 314 |
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id; |
| 315 |
id hex(b1) vc bc d f total y t |
| 316 |
42 1 Testing MySQL databases is a cool Must make it bug free for the customer 654321.4321 15.21 0 1965 2005-11-14 00:00:00 |
| 317 |
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id; |
| 318 |
id hex(b1) vc bc d f total y t |
| 319 |
42 1 Testing MySQL databases is a cool Must make it bug free for the customer 654321.4321 15.21 0 1965 2005-11-14 00:00:00 |
| 320 |
UPDATE t1 SET b1 = 0, t="2005-09-09" WHERE b1 = 1; |
| 321 |
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id; |
| 322 |
id hex(b1) vc bc d f total y t |
| 323 |
42 0 Testing MySQL databases is a cool Must make it bug free for the customer 654321.4321 15.21 0 1965 2005-09-09 00:00:00 |
| 324 |
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id; |
| 325 |
id hex(b1) vc bc d f total y t |
| 326 |
42 0 Testing MySQL databases is a cool Must make it bug free for the customer 654321.4321 15.21 0 1965 2005-09-09 00:00:00 |
| 327 |
DELETE FROM t1 WHERE id = 42; |
| 328 |
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id; |
| 329 |
id hex(b1) vc bc d f total y t |
| 330 |
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id; |
| 331 |
id hex(b1) vc bc d f total y t |
| 332 |
alter table t1 engine=memory; |
| 333 |
show create table t1; |
| 334 |
Table Create Table |
| 335 |
t1 CREATE TABLE `t1` ( |
| 336 |
`id` mediumint NOT NULL, |
| 337 |
`b1` bit(8) DEFAULT NULL, |
| 338 |
`vc` varchar(255) DEFAULT NULL, |
| 339 |
`bc` char(255) DEFAULT NULL, |
| 340 |
`d` decimal(10,4) DEFAULT '0.0000', |
| 341 |
`f` float DEFAULT '0', |
| 342 |
`total` bigint unsigned DEFAULT NULL, |
| 343 |
`y` year DEFAULT NULL, |
| 344 |
`t` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, |
| 345 |
PRIMARY KEY (`id`) |
| 346 |
) ENGINE=MEMORY DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci |
| 347 |
INSERT INTO t1 VALUES(42,1,'Testing MySQL databases is a cool ', 'Must make it bug free for the customer',654321.4321,15.21,0,1965,"2005-11-14"); |
| 348 |
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id; |
| 349 |
id hex(b1) vc bc d f total y t |
| 350 |
42 1 Testing MySQL databases is a cool Must make it bug free for the customer 654321.4321 15.21 0 1965 2005-11-14 00:00:00 |
| 351 |
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id; |
| 352 |
id hex(b1) vc bc d f total y t |
| 353 |
42 1 Testing MySQL databases is a cool Must make it bug free for the customer 654321.4321 15.21 0 1965 2005-11-14 00:00:00 |
| 354 |
UPDATE t1 SET b1 = 0, t="2005-09-09" WHERE b1 = 1; |
| 355 |
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id; |
| 356 |
id hex(b1) vc bc d f total y t |
| 357 |
42 0 Testing MySQL databases is a cool Must make it bug free for the customer 654321.4321 15.21 0 1965 2005-09-09 00:00:00 |
| 358 |
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id; |
| 359 |
id hex(b1) vc bc d f total y t |
| 360 |
42 0 Testing MySQL databases is a cool Must make it bug free for the customer 654321.4321 15.21 0 1965 2005-09-09 00:00:00 |
| 361 |
DELETE FROM t1 WHERE id = 42; |
| 362 |
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id; |
| 363 |
id hex(b1) vc bc d f total y t |
| 364 |
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id; |
| 365 |
id hex(b1) vc bc d f total y t |
| 366 |
DROP TABLE t1; |
| 367 |
include/sync_slave_sql_with_master.inc |
| 368 |
include/rpl_end.inc |