1DROP TABLE IF EXISTS t1; 2CREATE TABLE t1(c1 CHAR(30) NOT NULL, c2 CHAR(20) NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL); 3SHOW TABLES; 4Tables_in_test 5t1 6SHOW CREATE TABLE t1; 7Table Create Table 8t1 CREATE TABLE `t1` ( 9 `c1` char(30) NOT NULL, 10 `c2` char(20) NOT NULL, 11 `c3` int DEFAULT NULL, 12 `c4` varchar(10) NOT NULL 13) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 14ALTER TABLE t1 ADD PRIMARY KEY (c1,c2); 15SHOW TABLES; 16Tables_in_test 17t1 18SHOW CREATE TABLE t1; 19Table Create Table 20t1 CREATE TABLE `t1` ( 21 `c1` char(30) NOT NULL, 22 `c2` char(20) NOT NULL, 23 `c3` int DEFAULT NULL, 24 `c4` varchar(10) NOT NULL, 25 PRIMARY KEY (`c1`,`c2`) 26) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 27DROP TABLE t1; 28SHOW TABLES; 29Tables_in_test 30CREATE TABLE t1(c1 VARCHAR(30) NOT NULL, c2 CHAR(20) NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL); 31SHOW TABLES; 32Tables_in_test 33t1 34SHOW CREATE TABLE t1; 35Table Create Table 36t1 CREATE TABLE `t1` ( 37 `c1` varchar(30) NOT NULL, 38 `c2` char(20) NOT NULL, 39 `c3` int DEFAULT NULL, 40 `c4` varchar(10) NOT NULL 41) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 42ALTER TABLE t1 ADD PRIMARY KEY (c1,c2); 43SHOW TABLES; 44Tables_in_test 45t1 46SHOW CREATE TABLE t1; 47Table Create Table 48t1 CREATE TABLE `t1` ( 49 `c1` varchar(30) NOT NULL, 50 `c2` char(20) NOT NULL, 51 `c3` int DEFAULT NULL, 52 `c4` varchar(10) NOT NULL, 53 PRIMARY KEY (`c1`,`c2`) 54) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 55DROP TABLE t1; 56SHOW TABLES; 57Tables_in_test 58CREATE TABLE t1(c1 BINARY(30) NOT NULL, c2 CHAR(20) NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL); 59SHOW TABLES; 60Tables_in_test 61t1 62SHOW CREATE TABLE t1; 63Table Create Table 64t1 CREATE TABLE `t1` ( 65 `c1` binary(30) NOT NULL, 66 `c2` char(20) NOT NULL, 67 `c3` int DEFAULT NULL, 68 `c4` varchar(10) NOT NULL 69) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 70ALTER TABLE t1 ADD PRIMARY KEY (c1,c2); 71SHOW TABLES; 72Tables_in_test 73t1 74SHOW CREATE TABLE t1; 75Table Create Table 76t1 CREATE TABLE `t1` ( 77 `c1` binary(30) NOT NULL, 78 `c2` char(20) NOT NULL, 79 `c3` int DEFAULT NULL, 80 `c4` varchar(10) NOT NULL, 81 PRIMARY KEY (`c1`,`c2`) 82) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 83DROP TABLE t1; 84SHOW TABLES; 85Tables_in_test 86CREATE TABLE t1(c1 VARBINARY(30) NOT NULL, c2 CHAR(20) NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL); 87SHOW TABLES; 88Tables_in_test 89t1 90SHOW CREATE TABLE t1; 91Table Create Table 92t1 CREATE TABLE `t1` ( 93 `c1` varbinary(30) NOT NULL, 94 `c2` char(20) NOT NULL, 95 `c3` int DEFAULT NULL, 96 `c4` varchar(10) NOT NULL 97) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 98ALTER TABLE t1 ADD PRIMARY KEY (c1,c2); 99SHOW TABLES; 100Tables_in_test 101t1 102SHOW CREATE TABLE t1; 103Table Create Table 104t1 CREATE TABLE `t1` ( 105 `c1` varbinary(30) NOT NULL, 106 `c2` char(20) NOT NULL, 107 `c3` int DEFAULT NULL, 108 `c4` varchar(10) NOT NULL, 109 PRIMARY KEY (`c1`,`c2`) 110) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 111DROP TABLE t1; 112SHOW TABLES; 113Tables_in_test 114CREATE TABLE t1(c1 CHAR(30) NOT NULL, c2 VARCHAR(20) NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL); 115SHOW TABLES; 116Tables_in_test 117t1 118SHOW CREATE TABLE t1; 119Table Create Table 120t1 CREATE TABLE `t1` ( 121 `c1` char(30) NOT NULL, 122 `c2` varchar(20) NOT NULL, 123 `c3` int DEFAULT NULL, 124 `c4` varchar(10) NOT NULL 125) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 126ALTER TABLE t1 ADD PRIMARY KEY (c1,c2); 127SHOW TABLES; 128Tables_in_test 129t1 130SHOW CREATE TABLE t1; 131Table Create Table 132t1 CREATE TABLE `t1` ( 133 `c1` char(30) NOT NULL, 134 `c2` varchar(20) NOT NULL, 135 `c3` int DEFAULT NULL, 136 `c4` varchar(10) NOT NULL, 137 PRIMARY KEY (`c1`,`c2`) 138) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 139DROP TABLE t1; 140SHOW TABLES; 141Tables_in_test 142CREATE TABLE t1(c1 VARCHAR(30) NOT NULL, c2 VARCHAR(20) NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL); 143SHOW TABLES; 144Tables_in_test 145t1 146SHOW CREATE TABLE t1; 147Table Create Table 148t1 CREATE TABLE `t1` ( 149 `c1` varchar(30) NOT NULL, 150 `c2` varchar(20) NOT NULL, 151 `c3` int DEFAULT NULL, 152 `c4` varchar(10) NOT NULL 153) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 154ALTER TABLE t1 ADD PRIMARY KEY (c1,c2); 155SHOW TABLES; 156Tables_in_test 157t1 158SHOW CREATE TABLE t1; 159Table Create Table 160t1 CREATE TABLE `t1` ( 161 `c1` varchar(30) NOT NULL, 162 `c2` varchar(20) NOT NULL, 163 `c3` int DEFAULT NULL, 164 `c4` varchar(10) NOT NULL, 165 PRIMARY KEY (`c1`,`c2`) 166) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 167DROP TABLE t1; 168SHOW TABLES; 169Tables_in_test 170CREATE TABLE t1(c1 BINARY(30) NOT NULL, c2 VARCHAR(20) NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL); 171SHOW TABLES; 172Tables_in_test 173t1 174SHOW CREATE TABLE t1; 175Table Create Table 176t1 CREATE TABLE `t1` ( 177 `c1` binary(30) NOT NULL, 178 `c2` varchar(20) NOT NULL, 179 `c3` int DEFAULT NULL, 180 `c4` varchar(10) NOT NULL 181) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 182ALTER TABLE t1 ADD PRIMARY KEY (c1,c2); 183SHOW TABLES; 184Tables_in_test 185t1 186SHOW CREATE TABLE t1; 187Table Create Table 188t1 CREATE TABLE `t1` ( 189 `c1` binary(30) NOT NULL, 190 `c2` varchar(20) NOT NULL, 191 `c3` int DEFAULT NULL, 192 `c4` varchar(10) NOT NULL, 193 PRIMARY KEY (`c1`,`c2`) 194) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 195DROP TABLE t1; 196SHOW TABLES; 197Tables_in_test 198CREATE TABLE t1(c1 VARBINARY(30) NOT NULL, c2 VARCHAR(20) NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL); 199SHOW TABLES; 200Tables_in_test 201t1 202SHOW CREATE TABLE t1; 203Table Create Table 204t1 CREATE TABLE `t1` ( 205 `c1` varbinary(30) NOT NULL, 206 `c2` varchar(20) NOT NULL, 207 `c3` int DEFAULT NULL, 208 `c4` varchar(10) NOT NULL 209) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 210ALTER TABLE t1 ADD PRIMARY KEY (c1,c2); 211SHOW TABLES; 212Tables_in_test 213t1 214SHOW CREATE TABLE t1; 215Table Create Table 216t1 CREATE TABLE `t1` ( 217 `c1` varbinary(30) NOT NULL, 218 `c2` varchar(20) NOT NULL, 219 `c3` int DEFAULT NULL, 220 `c4` varchar(10) NOT NULL, 221 PRIMARY KEY (`c1`,`c2`) 222) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 223DROP TABLE t1; 224SHOW TABLES; 225Tables_in_test 226CREATE TABLE t1(c1 CHAR(30) NOT NULL, c2 BINARY(20) NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL); 227SHOW TABLES; 228Tables_in_test 229t1 230SHOW CREATE TABLE t1; 231Table Create Table 232t1 CREATE TABLE `t1` ( 233 `c1` char(30) NOT NULL, 234 `c2` binary(20) NOT NULL, 235 `c3` int DEFAULT NULL, 236 `c4` varchar(10) NOT NULL 237) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 238ALTER TABLE t1 ADD PRIMARY KEY (c1,c2); 239SHOW TABLES; 240Tables_in_test 241t1 242SHOW CREATE TABLE t1; 243Table Create Table 244t1 CREATE TABLE `t1` ( 245 `c1` char(30) NOT NULL, 246 `c2` binary(20) NOT NULL, 247 `c3` int DEFAULT NULL, 248 `c4` varchar(10) NOT NULL, 249 PRIMARY KEY (`c1`,`c2`) 250) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 251DROP TABLE t1; 252SHOW TABLES; 253Tables_in_test 254CREATE TABLE t1(c1 VARCHAR(30) NOT NULL, c2 BINARY(20) NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL); 255SHOW TABLES; 256Tables_in_test 257t1 258SHOW CREATE TABLE t1; 259Table Create Table 260t1 CREATE TABLE `t1` ( 261 `c1` varchar(30) NOT NULL, 262 `c2` binary(20) NOT NULL, 263 `c3` int DEFAULT NULL, 264 `c4` varchar(10) NOT NULL 265) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 266ALTER TABLE t1 ADD PRIMARY KEY (c1,c2); 267SHOW TABLES; 268Tables_in_test 269t1 270SHOW CREATE TABLE t1; 271Table Create Table 272t1 CREATE TABLE `t1` ( 273 `c1` varchar(30) NOT NULL, 274 `c2` binary(20) NOT NULL, 275 `c3` int DEFAULT NULL, 276 `c4` varchar(10) NOT NULL, 277 PRIMARY KEY (`c1`,`c2`) 278) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 279DROP TABLE t1; 280SHOW TABLES; 281Tables_in_test 282CREATE TABLE t1(c1 BINARY(30) NOT NULL, c2 BINARY(20) NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL); 283SHOW TABLES; 284Tables_in_test 285t1 286SHOW CREATE TABLE t1; 287Table Create Table 288t1 CREATE TABLE `t1` ( 289 `c1` binary(30) NOT NULL, 290 `c2` binary(20) NOT NULL, 291 `c3` int DEFAULT NULL, 292 `c4` varchar(10) NOT NULL 293) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 294ALTER TABLE t1 ADD PRIMARY KEY (c1,c2); 295SHOW TABLES; 296Tables_in_test 297t1 298SHOW CREATE TABLE t1; 299Table Create Table 300t1 CREATE TABLE `t1` ( 301 `c1` binary(30) NOT NULL, 302 `c2` binary(20) NOT NULL, 303 `c3` int DEFAULT NULL, 304 `c4` varchar(10) NOT NULL, 305 PRIMARY KEY (`c1`,`c2`) 306) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 307DROP TABLE t1; 308SHOW TABLES; 309Tables_in_test 310CREATE TABLE t1(c1 VARBINARY(30) NOT NULL, c2 BINARY(20) NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL); 311SHOW TABLES; 312Tables_in_test 313t1 314SHOW CREATE TABLE t1; 315Table Create Table 316t1 CREATE TABLE `t1` ( 317 `c1` varbinary(30) NOT NULL, 318 `c2` binary(20) NOT NULL, 319 `c3` int DEFAULT NULL, 320 `c4` varchar(10) NOT NULL 321) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 322ALTER TABLE t1 ADD PRIMARY KEY (c1,c2); 323SHOW TABLES; 324Tables_in_test 325t1 326SHOW CREATE TABLE t1; 327Table Create Table 328t1 CREATE TABLE `t1` ( 329 `c1` varbinary(30) NOT NULL, 330 `c2` binary(20) NOT NULL, 331 `c3` int DEFAULT NULL, 332 `c4` varchar(10) NOT NULL, 333 PRIMARY KEY (`c1`,`c2`) 334) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 335DROP TABLE t1; 336SHOW TABLES; 337Tables_in_test 338CREATE TABLE t1(c1 CHAR(30) NOT NULL, c2 VARBINARY(20) NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL); 339SHOW TABLES; 340Tables_in_test 341t1 342SHOW CREATE TABLE t1; 343Table Create Table 344t1 CREATE TABLE `t1` ( 345 `c1` char(30) NOT NULL, 346 `c2` varbinary(20) NOT NULL, 347 `c3` int DEFAULT NULL, 348 `c4` varchar(10) NOT NULL 349) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 350ALTER TABLE t1 ADD PRIMARY KEY (c1,c2); 351SHOW TABLES; 352Tables_in_test 353t1 354SHOW CREATE TABLE t1; 355Table Create Table 356t1 CREATE TABLE `t1` ( 357 `c1` char(30) NOT NULL, 358 `c2` varbinary(20) NOT NULL, 359 `c3` int DEFAULT NULL, 360 `c4` varchar(10) NOT NULL, 361 PRIMARY KEY (`c1`,`c2`) 362) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 363DROP TABLE t1; 364SHOW TABLES; 365Tables_in_test 366CREATE TABLE t1(c1 VARCHAR(30) NOT NULL, c2 VARBINARY(20) NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL); 367SHOW TABLES; 368Tables_in_test 369t1 370SHOW CREATE TABLE t1; 371Table Create Table 372t1 CREATE TABLE `t1` ( 373 `c1` varchar(30) NOT NULL, 374 `c2` varbinary(20) NOT NULL, 375 `c3` int DEFAULT NULL, 376 `c4` varchar(10) NOT NULL 377) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 378ALTER TABLE t1 ADD PRIMARY KEY (c1,c2); 379SHOW TABLES; 380Tables_in_test 381t1 382SHOW CREATE TABLE t1; 383Table Create Table 384t1 CREATE TABLE `t1` ( 385 `c1` varchar(30) NOT NULL, 386 `c2` varbinary(20) NOT NULL, 387 `c3` int DEFAULT NULL, 388 `c4` varchar(10) NOT NULL, 389 PRIMARY KEY (`c1`,`c2`) 390) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 391DROP TABLE t1; 392SHOW TABLES; 393Tables_in_test 394CREATE TABLE t1(c1 BINARY(30) NOT NULL, c2 VARBINARY(20) NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL); 395SHOW TABLES; 396Tables_in_test 397t1 398SHOW CREATE TABLE t1; 399Table Create Table 400t1 CREATE TABLE `t1` ( 401 `c1` binary(30) NOT NULL, 402 `c2` varbinary(20) NOT NULL, 403 `c3` int DEFAULT NULL, 404 `c4` varchar(10) NOT NULL 405) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 406ALTER TABLE t1 ADD PRIMARY KEY (c1,c2); 407SHOW TABLES; 408Tables_in_test 409t1 410SHOW CREATE TABLE t1; 411Table Create Table 412t1 CREATE TABLE `t1` ( 413 `c1` binary(30) NOT NULL, 414 `c2` varbinary(20) NOT NULL, 415 `c3` int DEFAULT NULL, 416 `c4` varchar(10) NOT NULL, 417 PRIMARY KEY (`c1`,`c2`) 418) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 419DROP TABLE t1; 420SHOW TABLES; 421Tables_in_test 422CREATE TABLE t1(c1 VARBINARY(30) NOT NULL, c2 VARBINARY(20) NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL); 423SHOW TABLES; 424Tables_in_test 425t1 426SHOW CREATE TABLE t1; 427Table Create Table 428t1 CREATE TABLE `t1` ( 429 `c1` varbinary(30) NOT NULL, 430 `c2` varbinary(20) NOT NULL, 431 `c3` int DEFAULT NULL, 432 `c4` varchar(10) NOT NULL 433) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 434ALTER TABLE t1 ADD PRIMARY KEY (c1,c2); 435SHOW TABLES; 436Tables_in_test 437t1 438SHOW CREATE TABLE t1; 439Table Create Table 440t1 CREATE TABLE `t1` ( 441 `c1` varbinary(30) NOT NULL, 442 `c2` varbinary(20) NOT NULL, 443 `c3` int DEFAULT NULL, 444 `c4` varchar(10) NOT NULL, 445 PRIMARY KEY (`c1`,`c2`) 446) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 447DROP TABLE t1; 448SHOW TABLES; 449Tables_in_test 450