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