1DROP TABLE IF EXISTS t5; 2CREATE TABLE t5(c1 INT NOT NULL PRIMARY KEY, c2 CHAR(10) NULL, c3 CHAR(20) NULL); 3SHOW TABLES; 4Tables_in_test 5t5 6SHOW CREATE TABLE t5; 7Table Create Table 8t5 CREATE TABLE `t5` ( 9 `c1` int NOT NULL, 10 `c2` char(10) DEFAULT NULL, 11 `c3` char(20) DEFAULT NULL, 12 PRIMARY KEY (`c1`) 13) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 14ALTER TABLE t5 ADD c4 CHAR(20) NULL AFTER c2; 15SHOW TABLES; 16Tables_in_test 17t5 18SHOW CREATE TABLE t5; 19Table Create Table 20t5 CREATE TABLE `t5` ( 21 `c1` int NOT NULL, 22 `c2` char(10) DEFAULT NULL, 23 `c4` char(20) DEFAULT NULL, 24 `c3` char(20) DEFAULT NULL, 25 PRIMARY KEY (`c1`) 26) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 27DROP TABLE t5; 28SHOW TABLES; 29Tables_in_test 30CREATE TABLE t5(c1 INT NOT NULL PRIMARY KEY, c2 VARCHAR(10) NULL, c3 VARCHAR(20) NULL); 31SHOW TABLES; 32Tables_in_test 33t5 34SHOW CREATE TABLE t5; 35Table Create Table 36t5 CREATE TABLE `t5` ( 37 `c1` int NOT NULL, 38 `c2` varchar(10) DEFAULT NULL, 39 `c3` varchar(20) DEFAULT NULL, 40 PRIMARY KEY (`c1`) 41) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 42ALTER TABLE t5 ADD c4 CHAR(20) NULL AFTER c2; 43SHOW TABLES; 44Tables_in_test 45t5 46SHOW CREATE TABLE t5; 47Table Create Table 48t5 CREATE TABLE `t5` ( 49 `c1` int NOT NULL, 50 `c2` varchar(10) DEFAULT NULL, 51 `c4` char(20) DEFAULT NULL, 52 `c3` varchar(20) DEFAULT NULL, 53 PRIMARY KEY (`c1`) 54) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 55DROP TABLE t5; 56SHOW TABLES; 57Tables_in_test 58CREATE TABLE t5(c1 INT NOT NULL PRIMARY KEY, c2 BINARY(10) NULL, c3 BINARY(20) NULL); 59SHOW TABLES; 60Tables_in_test 61t5 62SHOW CREATE TABLE t5; 63Table Create Table 64t5 CREATE TABLE `t5` ( 65 `c1` int NOT NULL, 66 `c2` binary(10) DEFAULT NULL, 67 `c3` binary(20) DEFAULT NULL, 68 PRIMARY KEY (`c1`) 69) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 70ALTER TABLE t5 ADD c4 CHAR(20) NULL AFTER c2; 71SHOW TABLES; 72Tables_in_test 73t5 74SHOW CREATE TABLE t5; 75Table Create Table 76t5 CREATE TABLE `t5` ( 77 `c1` int NOT NULL, 78 `c2` binary(10) DEFAULT NULL, 79 `c4` char(20) DEFAULT NULL, 80 `c3` binary(20) DEFAULT NULL, 81 PRIMARY KEY (`c1`) 82) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 83DROP TABLE t5; 84SHOW TABLES; 85Tables_in_test 86CREATE TABLE t5(c1 INT NOT NULL PRIMARY KEY, c2 VARBINARY(10) NULL, c3 VARBINARY(20) NULL); 87SHOW TABLES; 88Tables_in_test 89t5 90SHOW CREATE TABLE t5; 91Table Create Table 92t5 CREATE TABLE `t5` ( 93 `c1` int NOT NULL, 94 `c2` varbinary(10) DEFAULT NULL, 95 `c3` varbinary(20) DEFAULT NULL, 96 PRIMARY KEY (`c1`) 97) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 98ALTER TABLE t5 ADD c4 CHAR(20) NULL AFTER c2; 99SHOW TABLES; 100Tables_in_test 101t5 102SHOW CREATE TABLE t5; 103Table Create Table 104t5 CREATE TABLE `t5` ( 105 `c1` int NOT NULL, 106 `c2` varbinary(10) DEFAULT NULL, 107 `c4` char(20) DEFAULT NULL, 108 `c3` varbinary(20) DEFAULT NULL, 109 PRIMARY KEY (`c1`) 110) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 111DROP TABLE t5; 112SHOW TABLES; 113Tables_in_test 114CREATE TABLE t5(c1 INT NOT NULL PRIMARY KEY, c2 CHAR(10) NOT NULL, c3 CHAR(20) NOT NULL); 115SHOW TABLES; 116Tables_in_test 117t5 118SHOW CREATE TABLE t5; 119Table Create Table 120t5 CREATE TABLE `t5` ( 121 `c1` int NOT NULL, 122 `c2` char(10) NOT NULL, 123 `c3` char(20) NOT NULL, 124 PRIMARY KEY (`c1`) 125) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 126ALTER TABLE t5 ADD c4 CHAR(20) NOT NULL AFTER c2; 127SHOW TABLES; 128Tables_in_test 129t5 130SHOW CREATE TABLE t5; 131Table Create Table 132t5 CREATE TABLE `t5` ( 133 `c1` int NOT NULL, 134 `c2` char(10) NOT NULL, 135 `c4` char(20) NOT NULL, 136 `c3` char(20) NOT NULL, 137 PRIMARY KEY (`c1`) 138) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 139DROP TABLE t5; 140SHOW TABLES; 141Tables_in_test 142CREATE TABLE t5(c1 INT NOT NULL PRIMARY KEY, c2 VARCHAR(10) NOT NULL, c3 VARCHAR(20) NOT NULL); 143SHOW TABLES; 144Tables_in_test 145t5 146SHOW CREATE TABLE t5; 147Table Create Table 148t5 CREATE TABLE `t5` ( 149 `c1` int NOT NULL, 150 `c2` varchar(10) NOT NULL, 151 `c3` varchar(20) NOT NULL, 152 PRIMARY KEY (`c1`) 153) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 154ALTER TABLE t5 ADD c4 CHAR(20) NOT NULL AFTER c2; 155SHOW TABLES; 156Tables_in_test 157t5 158SHOW CREATE TABLE t5; 159Table Create Table 160t5 CREATE TABLE `t5` ( 161 `c1` int NOT NULL, 162 `c2` varchar(10) NOT NULL, 163 `c4` char(20) NOT NULL, 164 `c3` varchar(20) NOT NULL, 165 PRIMARY KEY (`c1`) 166) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 167DROP TABLE t5; 168SHOW TABLES; 169Tables_in_test 170CREATE TABLE t5(c1 INT NOT NULL PRIMARY KEY, c2 BINARY(10) NOT NULL, c3 BINARY(20) NOT NULL); 171SHOW TABLES; 172Tables_in_test 173t5 174SHOW CREATE TABLE t5; 175Table Create Table 176t5 CREATE TABLE `t5` ( 177 `c1` int NOT NULL, 178 `c2` binary(10) NOT NULL, 179 `c3` binary(20) NOT NULL, 180 PRIMARY KEY (`c1`) 181) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 182ALTER TABLE t5 ADD c4 CHAR(20) NOT NULL AFTER c2; 183SHOW TABLES; 184Tables_in_test 185t5 186SHOW CREATE TABLE t5; 187Table Create Table 188t5 CREATE TABLE `t5` ( 189 `c1` int NOT NULL, 190 `c2` binary(10) NOT NULL, 191 `c4` char(20) NOT NULL, 192 `c3` binary(20) NOT NULL, 193 PRIMARY KEY (`c1`) 194) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 195DROP TABLE t5; 196SHOW TABLES; 197Tables_in_test 198CREATE TABLE t5(c1 INT NOT NULL PRIMARY KEY, c2 VARBINARY(10) NOT NULL, c3 VARBINARY(20) NOT NULL); 199SHOW TABLES; 200Tables_in_test 201t5 202SHOW CREATE TABLE t5; 203Table Create Table 204t5 CREATE TABLE `t5` ( 205 `c1` int NOT NULL, 206 `c2` varbinary(10) NOT NULL, 207 `c3` varbinary(20) NOT NULL, 208 PRIMARY KEY (`c1`) 209) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 210ALTER TABLE t5 ADD c4 CHAR(20) NOT NULL AFTER c2; 211SHOW TABLES; 212Tables_in_test 213t5 214SHOW CREATE TABLE t5; 215Table Create Table 216t5 CREATE TABLE `t5` ( 217 `c1` int NOT NULL, 218 `c2` varbinary(10) NOT NULL, 219 `c4` char(20) NOT NULL, 220 `c3` varbinary(20) NOT NULL, 221 PRIMARY KEY (`c1`) 222) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 223DROP TABLE t5; 224SHOW TABLES; 225Tables_in_test 226CREATE TABLE t5(c1 INT NOT NULL PRIMARY KEY, c2 CHAR(10) NULL, c3 CHAR(20) NULL); 227SHOW TABLES; 228Tables_in_test 229t5 230SHOW CREATE TABLE t5; 231Table Create Table 232t5 CREATE TABLE `t5` ( 233 `c1` int NOT NULL, 234 `c2` char(10) DEFAULT NULL, 235 `c3` char(20) DEFAULT NULL, 236 PRIMARY KEY (`c1`) 237) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 238ALTER TABLE t5 ADD c4 VARCHAR(20) NULL AFTER c2; 239SHOW TABLES; 240Tables_in_test 241t5 242SHOW CREATE TABLE t5; 243Table Create Table 244t5 CREATE TABLE `t5` ( 245 `c1` int NOT NULL, 246 `c2` char(10) DEFAULT NULL, 247 `c4` varchar(20) DEFAULT NULL, 248 `c3` char(20) DEFAULT NULL, 249 PRIMARY KEY (`c1`) 250) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 251DROP TABLE t5; 252SHOW TABLES; 253Tables_in_test 254CREATE TABLE t5(c1 INT NOT NULL PRIMARY KEY, c2 VARCHAR(10) NULL, c3 VARCHAR(20) NULL); 255SHOW TABLES; 256Tables_in_test 257t5 258SHOW CREATE TABLE t5; 259Table Create Table 260t5 CREATE TABLE `t5` ( 261 `c1` int NOT NULL, 262 `c2` varchar(10) DEFAULT NULL, 263 `c3` varchar(20) DEFAULT NULL, 264 PRIMARY KEY (`c1`) 265) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 266ALTER TABLE t5 ADD c4 VARCHAR(20) NULL AFTER c2; 267SHOW TABLES; 268Tables_in_test 269t5 270SHOW CREATE TABLE t5; 271Table Create Table 272t5 CREATE TABLE `t5` ( 273 `c1` int NOT NULL, 274 `c2` varchar(10) DEFAULT NULL, 275 `c4` varchar(20) DEFAULT NULL, 276 `c3` varchar(20) DEFAULT NULL, 277 PRIMARY KEY (`c1`) 278) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 279DROP TABLE t5; 280SHOW TABLES; 281Tables_in_test 282CREATE TABLE t5(c1 INT NOT NULL PRIMARY KEY, c2 BINARY(10) NULL, c3 BINARY(20) NULL); 283SHOW TABLES; 284Tables_in_test 285t5 286SHOW CREATE TABLE t5; 287Table Create Table 288t5 CREATE TABLE `t5` ( 289 `c1` int NOT NULL, 290 `c2` binary(10) DEFAULT NULL, 291 `c3` binary(20) DEFAULT NULL, 292 PRIMARY KEY (`c1`) 293) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 294ALTER TABLE t5 ADD c4 VARCHAR(20) NULL AFTER c2; 295SHOW TABLES; 296Tables_in_test 297t5 298SHOW CREATE TABLE t5; 299Table Create Table 300t5 CREATE TABLE `t5` ( 301 `c1` int NOT NULL, 302 `c2` binary(10) DEFAULT NULL, 303 `c4` varchar(20) DEFAULT NULL, 304 `c3` binary(20) DEFAULT NULL, 305 PRIMARY KEY (`c1`) 306) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 307DROP TABLE t5; 308SHOW TABLES; 309Tables_in_test 310CREATE TABLE t5(c1 INT NOT NULL PRIMARY KEY, c2 VARBINARY(10) NULL, c3 VARBINARY(20) NULL); 311SHOW TABLES; 312Tables_in_test 313t5 314SHOW CREATE TABLE t5; 315Table Create Table 316t5 CREATE TABLE `t5` ( 317 `c1` int NOT NULL, 318 `c2` varbinary(10) DEFAULT NULL, 319 `c3` varbinary(20) DEFAULT NULL, 320 PRIMARY KEY (`c1`) 321) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 322ALTER TABLE t5 ADD c4 VARCHAR(20) NULL AFTER c2; 323SHOW TABLES; 324Tables_in_test 325t5 326SHOW CREATE TABLE t5; 327Table Create Table 328t5 CREATE TABLE `t5` ( 329 `c1` int NOT NULL, 330 `c2` varbinary(10) DEFAULT NULL, 331 `c4` varchar(20) DEFAULT NULL, 332 `c3` varbinary(20) DEFAULT NULL, 333 PRIMARY KEY (`c1`) 334) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 335DROP TABLE t5; 336SHOW TABLES; 337Tables_in_test 338CREATE TABLE t5(c1 INT NOT NULL PRIMARY KEY, c2 CHAR(10) NOT NULL, c3 CHAR(20) NOT NULL); 339SHOW TABLES; 340Tables_in_test 341t5 342SHOW CREATE TABLE t5; 343Table Create Table 344t5 CREATE TABLE `t5` ( 345 `c1` int NOT NULL, 346 `c2` char(10) NOT NULL, 347 `c3` char(20) NOT NULL, 348 PRIMARY KEY (`c1`) 349) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 350ALTER TABLE t5 ADD c4 VARCHAR(20) NOT NULL AFTER c2; 351SHOW TABLES; 352Tables_in_test 353t5 354SHOW CREATE TABLE t5; 355Table Create Table 356t5 CREATE TABLE `t5` ( 357 `c1` int NOT NULL, 358 `c2` char(10) NOT NULL, 359 `c4` varchar(20) NOT NULL, 360 `c3` char(20) NOT NULL, 361 PRIMARY KEY (`c1`) 362) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 363DROP TABLE t5; 364SHOW TABLES; 365Tables_in_test 366CREATE TABLE t5(c1 INT NOT NULL PRIMARY KEY, c2 VARCHAR(10) NOT NULL, c3 VARCHAR(20) NOT NULL); 367SHOW TABLES; 368Tables_in_test 369t5 370SHOW CREATE TABLE t5; 371Table Create Table 372t5 CREATE TABLE `t5` ( 373 `c1` int NOT NULL, 374 `c2` varchar(10) NOT NULL, 375 `c3` varchar(20) NOT NULL, 376 PRIMARY KEY (`c1`) 377) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 378ALTER TABLE t5 ADD c4 VARCHAR(20) NOT NULL AFTER c2; 379SHOW TABLES; 380Tables_in_test 381t5 382SHOW CREATE TABLE t5; 383Table Create Table 384t5 CREATE TABLE `t5` ( 385 `c1` int NOT NULL, 386 `c2` varchar(10) NOT NULL, 387 `c4` varchar(20) NOT NULL, 388 `c3` varchar(20) NOT NULL, 389 PRIMARY KEY (`c1`) 390) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 391DROP TABLE t5; 392SHOW TABLES; 393Tables_in_test 394CREATE TABLE t5(c1 INT NOT NULL PRIMARY KEY, c2 BINARY(10) NOT NULL, c3 BINARY(20) NOT NULL); 395SHOW TABLES; 396Tables_in_test 397t5 398SHOW CREATE TABLE t5; 399Table Create Table 400t5 CREATE TABLE `t5` ( 401 `c1` int NOT NULL, 402 `c2` binary(10) NOT NULL, 403 `c3` binary(20) NOT NULL, 404 PRIMARY KEY (`c1`) 405) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 406ALTER TABLE t5 ADD c4 VARCHAR(20) NOT NULL AFTER c2; 407SHOW TABLES; 408Tables_in_test 409t5 410SHOW CREATE TABLE t5; 411Table Create Table 412t5 CREATE TABLE `t5` ( 413 `c1` int NOT NULL, 414 `c2` binary(10) NOT NULL, 415 `c4` varchar(20) NOT NULL, 416 `c3` binary(20) NOT NULL, 417 PRIMARY KEY (`c1`) 418) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 419DROP TABLE t5; 420SHOW TABLES; 421Tables_in_test 422CREATE TABLE t5(c1 INT NOT NULL PRIMARY KEY, c2 VARBINARY(10) NOT NULL, c3 VARBINARY(20) NOT NULL); 423SHOW TABLES; 424Tables_in_test 425t5 426SHOW CREATE TABLE t5; 427Table Create Table 428t5 CREATE TABLE `t5` ( 429 `c1` int NOT NULL, 430 `c2` varbinary(10) NOT NULL, 431 `c3` varbinary(20) NOT NULL, 432 PRIMARY KEY (`c1`) 433) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 434ALTER TABLE t5 ADD c4 VARCHAR(20) NOT NULL AFTER c2; 435SHOW TABLES; 436Tables_in_test 437t5 438SHOW CREATE TABLE t5; 439Table Create Table 440t5 CREATE TABLE `t5` ( 441 `c1` int NOT NULL, 442 `c2` varbinary(10) NOT NULL, 443 `c4` varchar(20) NOT NULL, 444 `c3` varbinary(20) NOT NULL, 445 PRIMARY KEY (`c1`) 446) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 447DROP TABLE t5; 448SHOW TABLES; 449Tables_in_test 450CREATE TABLE t5(c1 INT NOT NULL PRIMARY KEY, c2 CHAR(10) NULL, c3 CHAR(20) NULL); 451SHOW TABLES; 452Tables_in_test 453t5 454SHOW CREATE TABLE t5; 455Table Create Table 456t5 CREATE TABLE `t5` ( 457 `c1` int NOT NULL, 458 `c2` char(10) DEFAULT NULL, 459 `c3` char(20) DEFAULT NULL, 460 PRIMARY KEY (`c1`) 461) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 462ALTER TABLE t5 ADD c4 BINARY(20) NULL AFTER c2; 463SHOW TABLES; 464Tables_in_test 465t5 466SHOW CREATE TABLE t5; 467Table Create Table 468t5 CREATE TABLE `t5` ( 469 `c1` int NOT NULL, 470 `c2` char(10) DEFAULT NULL, 471 `c4` binary(20) DEFAULT NULL, 472 `c3` char(20) DEFAULT NULL, 473 PRIMARY KEY (`c1`) 474) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 475DROP TABLE t5; 476SHOW TABLES; 477Tables_in_test 478CREATE TABLE t5(c1 INT NOT NULL PRIMARY KEY, c2 VARCHAR(10) NULL, c3 VARCHAR(20) NULL); 479SHOW TABLES; 480Tables_in_test 481t5 482SHOW CREATE TABLE t5; 483Table Create Table 484t5 CREATE TABLE `t5` ( 485 `c1` int NOT NULL, 486 `c2` varchar(10) DEFAULT NULL, 487 `c3` varchar(20) DEFAULT NULL, 488 PRIMARY KEY (`c1`) 489) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 490ALTER TABLE t5 ADD c4 BINARY(20) NULL AFTER c2; 491SHOW TABLES; 492Tables_in_test 493t5 494SHOW CREATE TABLE t5; 495Table Create Table 496t5 CREATE TABLE `t5` ( 497 `c1` int NOT NULL, 498 `c2` varchar(10) DEFAULT NULL, 499 `c4` binary(20) DEFAULT NULL, 500 `c3` varchar(20) DEFAULT NULL, 501 PRIMARY KEY (`c1`) 502) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 503DROP TABLE t5; 504SHOW TABLES; 505Tables_in_test 506CREATE TABLE t5(c1 INT NOT NULL PRIMARY KEY, c2 BINARY(10) NULL, c3 BINARY(20) NULL); 507SHOW TABLES; 508Tables_in_test 509t5 510SHOW CREATE TABLE t5; 511Table Create Table 512t5 CREATE TABLE `t5` ( 513 `c1` int NOT NULL, 514 `c2` binary(10) DEFAULT NULL, 515 `c3` binary(20) DEFAULT NULL, 516 PRIMARY KEY (`c1`) 517) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 518ALTER TABLE t5 ADD c4 BINARY(20) NULL AFTER c2; 519SHOW TABLES; 520Tables_in_test 521t5 522SHOW CREATE TABLE t5; 523Table Create Table 524t5 CREATE TABLE `t5` ( 525 `c1` int NOT NULL, 526 `c2` binary(10) DEFAULT NULL, 527 `c4` binary(20) DEFAULT NULL, 528 `c3` binary(20) DEFAULT NULL, 529 PRIMARY KEY (`c1`) 530) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 531DROP TABLE t5; 532SHOW TABLES; 533Tables_in_test 534CREATE TABLE t5(c1 INT NOT NULL PRIMARY KEY, c2 VARBINARY(10) NULL, c3 VARBINARY(20) NULL); 535SHOW TABLES; 536Tables_in_test 537t5 538SHOW CREATE TABLE t5; 539Table Create Table 540t5 CREATE TABLE `t5` ( 541 `c1` int NOT NULL, 542 `c2` varbinary(10) DEFAULT NULL, 543 `c3` varbinary(20) DEFAULT NULL, 544 PRIMARY KEY (`c1`) 545) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 546ALTER TABLE t5 ADD c4 BINARY(20) NULL AFTER c2; 547SHOW TABLES; 548Tables_in_test 549t5 550SHOW CREATE TABLE t5; 551Table Create Table 552t5 CREATE TABLE `t5` ( 553 `c1` int NOT NULL, 554 `c2` varbinary(10) DEFAULT NULL, 555 `c4` binary(20) DEFAULT NULL, 556 `c3` varbinary(20) DEFAULT NULL, 557 PRIMARY KEY (`c1`) 558) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 559DROP TABLE t5; 560SHOW TABLES; 561Tables_in_test 562CREATE TABLE t5(c1 INT NOT NULL PRIMARY KEY, c2 CHAR(10) NOT NULL, c3 CHAR(20) NOT NULL); 563SHOW TABLES; 564Tables_in_test 565t5 566SHOW CREATE TABLE t5; 567Table Create Table 568t5 CREATE TABLE `t5` ( 569 `c1` int NOT NULL, 570 `c2` char(10) NOT NULL, 571 `c3` char(20) NOT NULL, 572 PRIMARY KEY (`c1`) 573) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 574ALTER TABLE t5 ADD c4 BINARY(20) NOT NULL AFTER c2; 575SHOW TABLES; 576Tables_in_test 577t5 578SHOW CREATE TABLE t5; 579Table Create Table 580t5 CREATE TABLE `t5` ( 581 `c1` int NOT NULL, 582 `c2` char(10) NOT NULL, 583 `c4` binary(20) NOT NULL, 584 `c3` char(20) NOT NULL, 585 PRIMARY KEY (`c1`) 586) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 587DROP TABLE t5; 588SHOW TABLES; 589Tables_in_test 590CREATE TABLE t5(c1 INT NOT NULL PRIMARY KEY, c2 VARCHAR(10) NOT NULL, c3 VARCHAR(20) NOT NULL); 591SHOW TABLES; 592Tables_in_test 593t5 594SHOW CREATE TABLE t5; 595Table Create Table 596t5 CREATE TABLE `t5` ( 597 `c1` int NOT NULL, 598 `c2` varchar(10) NOT NULL, 599 `c3` varchar(20) NOT NULL, 600 PRIMARY KEY (`c1`) 601) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 602ALTER TABLE t5 ADD c4 BINARY(20) NOT NULL AFTER c2; 603SHOW TABLES; 604Tables_in_test 605t5 606SHOW CREATE TABLE t5; 607Table Create Table 608t5 CREATE TABLE `t5` ( 609 `c1` int NOT NULL, 610 `c2` varchar(10) NOT NULL, 611 `c4` binary(20) NOT NULL, 612 `c3` varchar(20) NOT NULL, 613 PRIMARY KEY (`c1`) 614) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 615DROP TABLE t5; 616SHOW TABLES; 617Tables_in_test 618CREATE TABLE t5(c1 INT NOT NULL PRIMARY KEY, c2 BINARY(10) NOT NULL, c3 BINARY(20) NOT NULL); 619SHOW TABLES; 620Tables_in_test 621t5 622SHOW CREATE TABLE t5; 623Table Create Table 624t5 CREATE TABLE `t5` ( 625 `c1` int NOT NULL, 626 `c2` binary(10) NOT NULL, 627 `c3` binary(20) NOT NULL, 628 PRIMARY KEY (`c1`) 629) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 630ALTER TABLE t5 ADD c4 BINARY(20) NOT NULL AFTER c2; 631SHOW TABLES; 632Tables_in_test 633t5 634SHOW CREATE TABLE t5; 635Table Create Table 636t5 CREATE TABLE `t5` ( 637 `c1` int NOT NULL, 638 `c2` binary(10) NOT NULL, 639 `c4` binary(20) NOT NULL, 640 `c3` binary(20) NOT NULL, 641 PRIMARY KEY (`c1`) 642) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 643DROP TABLE t5; 644SHOW TABLES; 645Tables_in_test 646CREATE TABLE t5(c1 INT NOT NULL PRIMARY KEY, c2 VARBINARY(10) NOT NULL, c3 VARBINARY(20) NOT NULL); 647SHOW TABLES; 648Tables_in_test 649t5 650SHOW CREATE TABLE t5; 651Table Create Table 652t5 CREATE TABLE `t5` ( 653 `c1` int NOT NULL, 654 `c2` varbinary(10) NOT NULL, 655 `c3` varbinary(20) NOT NULL, 656 PRIMARY KEY (`c1`) 657) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 658ALTER TABLE t5 ADD c4 BINARY(20) NOT NULL AFTER c2; 659SHOW TABLES; 660Tables_in_test 661t5 662SHOW CREATE TABLE t5; 663Table Create Table 664t5 CREATE TABLE `t5` ( 665 `c1` int NOT NULL, 666 `c2` varbinary(10) NOT NULL, 667 `c4` binary(20) NOT NULL, 668 `c3` varbinary(20) NOT NULL, 669 PRIMARY KEY (`c1`) 670) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 671DROP TABLE t5; 672SHOW TABLES; 673Tables_in_test 674CREATE TABLE t5(c1 INT NOT NULL PRIMARY KEY, c2 CHAR(10) NULL, c3 CHAR(20) NULL); 675SHOW TABLES; 676Tables_in_test 677t5 678SHOW CREATE TABLE t5; 679Table Create Table 680t5 CREATE TABLE `t5` ( 681 `c1` int NOT NULL, 682 `c2` char(10) DEFAULT NULL, 683 `c3` char(20) DEFAULT NULL, 684 PRIMARY KEY (`c1`) 685) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 686ALTER TABLE t5 ADD c4 VARBINARY(20) NULL AFTER c2; 687SHOW TABLES; 688Tables_in_test 689t5 690SHOW CREATE TABLE t5; 691Table Create Table 692t5 CREATE TABLE `t5` ( 693 `c1` int NOT NULL, 694 `c2` char(10) DEFAULT NULL, 695 `c4` varbinary(20) DEFAULT NULL, 696 `c3` char(20) DEFAULT NULL, 697 PRIMARY KEY (`c1`) 698) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 699DROP TABLE t5; 700SHOW TABLES; 701Tables_in_test 702CREATE TABLE t5(c1 INT NOT NULL PRIMARY KEY, c2 VARCHAR(10) NULL, c3 VARCHAR(20) NULL); 703SHOW TABLES; 704Tables_in_test 705t5 706SHOW CREATE TABLE t5; 707Table Create Table 708t5 CREATE TABLE `t5` ( 709 `c1` int NOT NULL, 710 `c2` varchar(10) DEFAULT NULL, 711 `c3` varchar(20) DEFAULT NULL, 712 PRIMARY KEY (`c1`) 713) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 714ALTER TABLE t5 ADD c4 VARBINARY(20) NULL AFTER c2; 715SHOW TABLES; 716Tables_in_test 717t5 718SHOW CREATE TABLE t5; 719Table Create Table 720t5 CREATE TABLE `t5` ( 721 `c1` int NOT NULL, 722 `c2` varchar(10) DEFAULT NULL, 723 `c4` varbinary(20) DEFAULT NULL, 724 `c3` varchar(20) DEFAULT NULL, 725 PRIMARY KEY (`c1`) 726) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 727DROP TABLE t5; 728SHOW TABLES; 729Tables_in_test 730CREATE TABLE t5(c1 INT NOT NULL PRIMARY KEY, c2 BINARY(10) NULL, c3 BINARY(20) NULL); 731SHOW TABLES; 732Tables_in_test 733t5 734SHOW CREATE TABLE t5; 735Table Create Table 736t5 CREATE TABLE `t5` ( 737 `c1` int NOT NULL, 738 `c2` binary(10) DEFAULT NULL, 739 `c3` binary(20) DEFAULT NULL, 740 PRIMARY KEY (`c1`) 741) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 742ALTER TABLE t5 ADD c4 VARBINARY(20) NULL AFTER c2; 743SHOW TABLES; 744Tables_in_test 745t5 746SHOW CREATE TABLE t5; 747Table Create Table 748t5 CREATE TABLE `t5` ( 749 `c1` int NOT NULL, 750 `c2` binary(10) DEFAULT NULL, 751 `c4` varbinary(20) DEFAULT NULL, 752 `c3` binary(20) DEFAULT NULL, 753 PRIMARY KEY (`c1`) 754) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 755DROP TABLE t5; 756SHOW TABLES; 757Tables_in_test 758CREATE TABLE t5(c1 INT NOT NULL PRIMARY KEY, c2 VARBINARY(10) NULL, c3 VARBINARY(20) NULL); 759SHOW TABLES; 760Tables_in_test 761t5 762SHOW CREATE TABLE t5; 763Table Create Table 764t5 CREATE TABLE `t5` ( 765 `c1` int NOT NULL, 766 `c2` varbinary(10) DEFAULT NULL, 767 `c3` varbinary(20) DEFAULT NULL, 768 PRIMARY KEY (`c1`) 769) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 770ALTER TABLE t5 ADD c4 VARBINARY(20) NULL AFTER c2; 771SHOW TABLES; 772Tables_in_test 773t5 774SHOW CREATE TABLE t5; 775Table Create Table 776t5 CREATE TABLE `t5` ( 777 `c1` int NOT NULL, 778 `c2` varbinary(10) DEFAULT NULL, 779 `c4` varbinary(20) DEFAULT NULL, 780 `c3` varbinary(20) DEFAULT NULL, 781 PRIMARY KEY (`c1`) 782) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 783DROP TABLE t5; 784SHOW TABLES; 785Tables_in_test 786CREATE TABLE t5(c1 INT NOT NULL PRIMARY KEY, c2 CHAR(10) NOT NULL, c3 CHAR(20) NOT NULL); 787SHOW TABLES; 788Tables_in_test 789t5 790SHOW CREATE TABLE t5; 791Table Create Table 792t5 CREATE TABLE `t5` ( 793 `c1` int NOT NULL, 794 `c2` char(10) NOT NULL, 795 `c3` char(20) NOT NULL, 796 PRIMARY KEY (`c1`) 797) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 798ALTER TABLE t5 ADD c4 VARBINARY(20) NOT NULL AFTER c2; 799SHOW TABLES; 800Tables_in_test 801t5 802SHOW CREATE TABLE t5; 803Table Create Table 804t5 CREATE TABLE `t5` ( 805 `c1` int NOT NULL, 806 `c2` char(10) NOT NULL, 807 `c4` varbinary(20) NOT NULL, 808 `c3` char(20) NOT NULL, 809 PRIMARY KEY (`c1`) 810) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 811DROP TABLE t5; 812SHOW TABLES; 813Tables_in_test 814CREATE TABLE t5(c1 INT NOT NULL PRIMARY KEY, c2 VARCHAR(10) NOT NULL, c3 VARCHAR(20) NOT NULL); 815SHOW TABLES; 816Tables_in_test 817t5 818SHOW CREATE TABLE t5; 819Table Create Table 820t5 CREATE TABLE `t5` ( 821 `c1` int NOT NULL, 822 `c2` varchar(10) NOT NULL, 823 `c3` varchar(20) NOT NULL, 824 PRIMARY KEY (`c1`) 825) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 826ALTER TABLE t5 ADD c4 VARBINARY(20) NOT NULL AFTER c2; 827SHOW TABLES; 828Tables_in_test 829t5 830SHOW CREATE TABLE t5; 831Table Create Table 832t5 CREATE TABLE `t5` ( 833 `c1` int NOT NULL, 834 `c2` varchar(10) NOT NULL, 835 `c4` varbinary(20) NOT NULL, 836 `c3` varchar(20) NOT NULL, 837 PRIMARY KEY (`c1`) 838) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 839DROP TABLE t5; 840SHOW TABLES; 841Tables_in_test 842CREATE TABLE t5(c1 INT NOT NULL PRIMARY KEY, c2 BINARY(10) NOT NULL, c3 BINARY(20) NOT NULL); 843SHOW TABLES; 844Tables_in_test 845t5 846SHOW CREATE TABLE t5; 847Table Create Table 848t5 CREATE TABLE `t5` ( 849 `c1` int NOT NULL, 850 `c2` binary(10) NOT NULL, 851 `c3` binary(20) NOT NULL, 852 PRIMARY KEY (`c1`) 853) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 854ALTER TABLE t5 ADD c4 VARBINARY(20) NOT NULL AFTER c2; 855SHOW TABLES; 856Tables_in_test 857t5 858SHOW CREATE TABLE t5; 859Table Create Table 860t5 CREATE TABLE `t5` ( 861 `c1` int NOT NULL, 862 `c2` binary(10) NOT NULL, 863 `c4` varbinary(20) NOT NULL, 864 `c3` binary(20) NOT NULL, 865 PRIMARY KEY (`c1`) 866) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 867DROP TABLE t5; 868SHOW TABLES; 869Tables_in_test 870CREATE TABLE t5(c1 INT NOT NULL PRIMARY KEY, c2 VARBINARY(10) NOT NULL, c3 VARBINARY(20) NOT NULL); 871SHOW TABLES; 872Tables_in_test 873t5 874SHOW CREATE TABLE t5; 875Table Create Table 876t5 CREATE TABLE `t5` ( 877 `c1` int NOT NULL, 878 `c2` varbinary(10) NOT NULL, 879 `c3` varbinary(20) NOT NULL, 880 PRIMARY KEY (`c1`) 881) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 882ALTER TABLE t5 ADD c4 VARBINARY(20) NOT NULL AFTER c2; 883SHOW TABLES; 884Tables_in_test 885t5 886SHOW CREATE TABLE t5; 887Table Create Table 888t5 CREATE TABLE `t5` ( 889 `c1` int NOT NULL, 890 `c2` varbinary(10) NOT NULL, 891 `c4` varbinary(20) NOT NULL, 892 `c3` varbinary(20) NOT NULL, 893 PRIMARY KEY (`c1`) 894) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 895DROP TABLE t5; 896SHOW TABLES; 897Tables_in_test 898