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