1DROP TABLE IF EXISTS t3; 2CREATE TABLE t3(c1 TINYINT NULL); 3SHOW TABLES; 4Tables_in_test 5t3 6SHOW CREATE TABLE t3; 7Table Create Table 8t3 CREATE TABLE `t3` ( 9 `c1` tinyint DEFAULT NULL 10) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 11ALTER TABLE t3 MODIFY c1 TINYINT UNSIGNED NULL; 12SHOW TABLES; 13Tables_in_test 14t3 15SHOW CREATE TABLE t3; 16Table Create Table 17t3 CREATE TABLE `t3` ( 18 `c1` tinyint unsigned 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 NULL); 24SHOW TABLES; 25Tables_in_test 26t3 27SHOW CREATE TABLE t3; 28Table Create Table 29t3 CREATE TABLE `t3` ( 30 `c1` smallint DEFAULT NULL 31) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 32ALTER TABLE t3 MODIFY c1 SMALLINT UNSIGNED NULL; 33SHOW TABLES; 34Tables_in_test 35t3 36SHOW CREATE TABLE t3; 37Table Create Table 38t3 CREATE TABLE `t3` ( 39 `c1` smallint unsigned 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 NULL); 45SHOW TABLES; 46Tables_in_test 47t3 48SHOW CREATE TABLE t3; 49Table Create Table 50t3 CREATE TABLE `t3` ( 51 `c1` mediumint DEFAULT NULL 52) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 53ALTER TABLE t3 MODIFY c1 MEDIUMINT UNSIGNED NULL; 54SHOW TABLES; 55Tables_in_test 56t3 57SHOW CREATE TABLE t3; 58Table Create Table 59t3 CREATE TABLE `t3` ( 60 `c1` mediumint unsigned 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 NULL); 66SHOW TABLES; 67Tables_in_test 68t3 69SHOW CREATE TABLE t3; 70Table Create Table 71t3 CREATE TABLE `t3` ( 72 `c1` int DEFAULT NULL 73) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 74ALTER TABLE t3 MODIFY c1 INT UNSIGNED NULL; 75SHOW TABLES; 76Tables_in_test 77t3 78SHOW CREATE TABLE t3; 79Table Create Table 80t3 CREATE TABLE `t3` ( 81 `c1` int unsigned 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 NULL); 87SHOW TABLES; 88Tables_in_test 89t3 90SHOW CREATE TABLE t3; 91Table Create Table 92t3 CREATE TABLE `t3` ( 93 `c1` int DEFAULT NULL 94) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 95ALTER TABLE t3 MODIFY c1 INTEGER UNSIGNED NULL; 96SHOW TABLES; 97Tables_in_test 98t3 99SHOW CREATE TABLE t3; 100Table Create Table 101t3 CREATE TABLE `t3` ( 102 `c1` int unsigned 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 NULL); 108SHOW TABLES; 109Tables_in_test 110t3 111SHOW CREATE TABLE t3; 112Table Create Table 113t3 CREATE TABLE `t3` ( 114 `c1` bigint DEFAULT NULL 115) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 116ALTER TABLE t3 MODIFY c1 BIGINT UNSIGNED NULL; 117SHOW TABLES; 118Tables_in_test 119t3 120SHOW CREATE TABLE t3; 121Table Create Table 122t3 CREATE TABLE `t3` ( 123 `c1` bigint unsigned 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 NULL); 129SHOW TABLES; 130Tables_in_test 131t3 132SHOW CREATE TABLE t3; 133Table Create Table 134t3 CREATE TABLE `t3` ( 135 `c1` double DEFAULT NULL 136) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 137ALTER TABLE t3 MODIFY c1 REAL UNSIGNED NULL; 138Warnings: 139Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release. 140SHOW TABLES; 141Tables_in_test 142t3 143SHOW CREATE TABLE t3; 144Table Create Table 145t3 CREATE TABLE `t3` ( 146 `c1` double unsigned 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 NULL); 152SHOW TABLES; 153Tables_in_test 154t3 155SHOW CREATE TABLE t3; 156Table Create Table 157t3 CREATE TABLE `t3` ( 158 `c1` double DEFAULT NULL 159) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 160ALTER TABLE t3 MODIFY c1 DOUBLE UNSIGNED NULL; 161Warnings: 162Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release. 163SHOW TABLES; 164Tables_in_test 165t3 166SHOW CREATE TABLE t3; 167Table Create Table 168t3 CREATE TABLE `t3` ( 169 `c1` double unsigned 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 NULL); 175SHOW TABLES; 176Tables_in_test 177t3 178SHOW CREATE TABLE t3; 179Table Create Table 180t3 CREATE TABLE `t3` ( 181 `c1` float DEFAULT NULL 182) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 183ALTER TABLE t3 MODIFY c1 FLOAT UNSIGNED NULL; 184Warnings: 185Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release. 186SHOW TABLES; 187Tables_in_test 188t3 189SHOW CREATE TABLE t3; 190Table Create Table 191t3 CREATE TABLE `t3` ( 192 `c1` float unsigned 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 NULL); 198SHOW TABLES; 199Tables_in_test 200t3 201SHOW CREATE TABLE t3; 202Table Create Table 203t3 CREATE TABLE `t3` ( 204 `c1` decimal(10,0) DEFAULT NULL 205) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 206ALTER TABLE t3 MODIFY c1 DECIMAL UNSIGNED NULL; 207Warnings: 208Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release. 209SHOW TABLES; 210Tables_in_test 211t3 212SHOW CREATE TABLE t3; 213Table Create Table 214t3 CREATE TABLE `t3` ( 215 `c1` decimal(10,0) unsigned 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 NULL); 221SHOW TABLES; 222Tables_in_test 223t3 224SHOW CREATE TABLE t3; 225Table Create Table 226t3 CREATE TABLE `t3` ( 227 `c1` decimal(10,0) DEFAULT NULL 228) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 229ALTER TABLE t3 MODIFY c1 NUMERIC UNSIGNED NULL; 230Warnings: 231Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release. 232SHOW TABLES; 233Tables_in_test 234t3 235SHOW CREATE TABLE t3; 236Table Create Table 237t3 CREATE TABLE `t3` ( 238 `c1` decimal(10,0) unsigned 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 NULL); 244SHOW TABLES; 245Tables_in_test 246t3 247SHOW CREATE TABLE t3; 248Table Create Table 249t3 CREATE TABLE `t3` ( 250 `c1` tinyint DEFAULT NULL 251) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 252ALTER TABLE t3 CHANGE c1 c1 TINYINT UNSIGNED NULL; 253SHOW TABLES; 254Tables_in_test 255t3 256SHOW CREATE TABLE t3; 257Table Create Table 258t3 CREATE TABLE `t3` ( 259 `c1` tinyint unsigned 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 NULL); 265SHOW TABLES; 266Tables_in_test 267t3 268SHOW CREATE TABLE t3; 269Table Create Table 270t3 CREATE TABLE `t3` ( 271 `c1` smallint DEFAULT NULL 272) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 273ALTER TABLE t3 CHANGE c1 c1 SMALLINT UNSIGNED NULL; 274SHOW TABLES; 275Tables_in_test 276t3 277SHOW CREATE TABLE t3; 278Table Create Table 279t3 CREATE TABLE `t3` ( 280 `c1` smallint unsigned 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 NULL); 286SHOW TABLES; 287Tables_in_test 288t3 289SHOW CREATE TABLE t3; 290Table Create Table 291t3 CREATE TABLE `t3` ( 292 `c1` mediumint DEFAULT NULL 293) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 294ALTER TABLE t3 CHANGE c1 c1 MEDIUMINT UNSIGNED NULL; 295SHOW TABLES; 296Tables_in_test 297t3 298SHOW CREATE TABLE t3; 299Table Create Table 300t3 CREATE TABLE `t3` ( 301 `c1` mediumint unsigned 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 NULL); 307SHOW TABLES; 308Tables_in_test 309t3 310SHOW CREATE TABLE t3; 311Table Create Table 312t3 CREATE TABLE `t3` ( 313 `c1` int DEFAULT NULL 314) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 315ALTER TABLE t3 CHANGE c1 c1 INT UNSIGNED NULL; 316SHOW TABLES; 317Tables_in_test 318t3 319SHOW CREATE TABLE t3; 320Table Create Table 321t3 CREATE TABLE `t3` ( 322 `c1` int unsigned 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 NULL); 328SHOW TABLES; 329Tables_in_test 330t3 331SHOW CREATE TABLE t3; 332Table Create Table 333t3 CREATE TABLE `t3` ( 334 `c1` int DEFAULT NULL 335) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 336ALTER TABLE t3 CHANGE c1 c1 INTEGER UNSIGNED NULL; 337SHOW TABLES; 338Tables_in_test 339t3 340SHOW CREATE TABLE t3; 341Table Create Table 342t3 CREATE TABLE `t3` ( 343 `c1` int unsigned 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 NULL); 349SHOW TABLES; 350Tables_in_test 351t3 352SHOW CREATE TABLE t3; 353Table Create Table 354t3 CREATE TABLE `t3` ( 355 `c1` bigint DEFAULT NULL 356) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 357ALTER TABLE t3 CHANGE c1 c1 BIGINT UNSIGNED NULL; 358SHOW TABLES; 359Tables_in_test 360t3 361SHOW CREATE TABLE t3; 362Table Create Table 363t3 CREATE TABLE `t3` ( 364 `c1` bigint unsigned 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 NULL); 370SHOW TABLES; 371Tables_in_test 372t3 373SHOW CREATE TABLE t3; 374Table Create Table 375t3 CREATE TABLE `t3` ( 376 `c1` double DEFAULT NULL 377) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 378ALTER TABLE t3 CHANGE c1 c1 REAL UNSIGNED NULL; 379Warnings: 380Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release. 381SHOW TABLES; 382Tables_in_test 383t3 384SHOW CREATE TABLE t3; 385Table Create Table 386t3 CREATE TABLE `t3` ( 387 `c1` double unsigned 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 NULL); 393SHOW TABLES; 394Tables_in_test 395t3 396SHOW CREATE TABLE t3; 397Table Create Table 398t3 CREATE TABLE `t3` ( 399 `c1` double DEFAULT NULL 400) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 401ALTER TABLE t3 CHANGE c1 c1 DOUBLE UNSIGNED NULL; 402Warnings: 403Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release. 404SHOW TABLES; 405Tables_in_test 406t3 407SHOW CREATE TABLE t3; 408Table Create Table 409t3 CREATE TABLE `t3` ( 410 `c1` double unsigned 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 NULL); 416SHOW TABLES; 417Tables_in_test 418t3 419SHOW CREATE TABLE t3; 420Table Create Table 421t3 CREATE TABLE `t3` ( 422 `c1` float DEFAULT NULL 423) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 424ALTER TABLE t3 CHANGE c1 c1 FLOAT UNSIGNED NULL; 425Warnings: 426Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release. 427SHOW TABLES; 428Tables_in_test 429t3 430SHOW CREATE TABLE t3; 431Table Create Table 432t3 CREATE TABLE `t3` ( 433 `c1` float unsigned 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 NULL); 439SHOW TABLES; 440Tables_in_test 441t3 442SHOW CREATE TABLE t3; 443Table Create Table 444t3 CREATE TABLE `t3` ( 445 `c1` decimal(10,0) DEFAULT NULL 446) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 447ALTER TABLE t3 CHANGE c1 c1 DECIMAL UNSIGNED NULL; 448Warnings: 449Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release. 450SHOW TABLES; 451Tables_in_test 452t3 453SHOW CREATE TABLE t3; 454Table Create Table 455t3 CREATE TABLE `t3` ( 456 `c1` decimal(10,0) unsigned 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 NULL); 462SHOW TABLES; 463Tables_in_test 464t3 465SHOW CREATE TABLE t3; 466Table Create Table 467t3 CREATE TABLE `t3` ( 468 `c1` decimal(10,0) DEFAULT NULL 469) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 470ALTER TABLE t3 CHANGE c1 c1 NUMERIC UNSIGNED NULL; 471Warnings: 472Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release. 473SHOW TABLES; 474Tables_in_test 475t3 476SHOW CREATE TABLE t3; 477Table Create Table 478t3 CREATE TABLE `t3` ( 479 `c1` decimal(10,0) unsigned 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 NOT NULL); 485SHOW TABLES; 486Tables_in_test 487t3 488SHOW CREATE TABLE t3; 489Table Create Table 490t3 CREATE TABLE `t3` ( 491 `c1` tinyint NOT NULL 492) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 493ALTER TABLE t3 MODIFY c1 TINYINT UNSIGNED NOT NULL; 494SHOW TABLES; 495Tables_in_test 496t3 497SHOW CREATE TABLE t3; 498Table Create Table 499t3 CREATE TABLE `t3` ( 500 `c1` tinyint unsigned 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 NOT NULL); 506SHOW TABLES; 507Tables_in_test 508t3 509SHOW CREATE TABLE t3; 510Table Create Table 511t3 CREATE TABLE `t3` ( 512 `c1` smallint NOT NULL 513) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 514ALTER TABLE t3 MODIFY c1 SMALLINT UNSIGNED NOT NULL; 515SHOW TABLES; 516Tables_in_test 517t3 518SHOW CREATE TABLE t3; 519Table Create Table 520t3 CREATE TABLE `t3` ( 521 `c1` smallint unsigned 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 NOT NULL); 527SHOW TABLES; 528Tables_in_test 529t3 530SHOW CREATE TABLE t3; 531Table Create Table 532t3 CREATE TABLE `t3` ( 533 `c1` mediumint NOT NULL 534) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 535ALTER TABLE t3 MODIFY c1 MEDIUMINT UNSIGNED NOT NULL; 536SHOW TABLES; 537Tables_in_test 538t3 539SHOW CREATE TABLE t3; 540Table Create Table 541t3 CREATE TABLE `t3` ( 542 `c1` mediumint unsigned 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 NOT NULL); 548SHOW TABLES; 549Tables_in_test 550t3 551SHOW CREATE TABLE t3; 552Table Create Table 553t3 CREATE TABLE `t3` ( 554 `c1` int NOT NULL 555) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 556ALTER TABLE t3 MODIFY c1 INT UNSIGNED NOT NULL; 557SHOW TABLES; 558Tables_in_test 559t3 560SHOW CREATE TABLE t3; 561Table Create Table 562t3 CREATE TABLE `t3` ( 563 `c1` int unsigned 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 NOT NULL); 569SHOW TABLES; 570Tables_in_test 571t3 572SHOW CREATE TABLE t3; 573Table Create Table 574t3 CREATE TABLE `t3` ( 575 `c1` int NOT NULL 576) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 577ALTER TABLE t3 MODIFY c1 INTEGER UNSIGNED NOT NULL; 578SHOW TABLES; 579Tables_in_test 580t3 581SHOW CREATE TABLE t3; 582Table Create Table 583t3 CREATE TABLE `t3` ( 584 `c1` int unsigned 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 NOT NULL); 590SHOW TABLES; 591Tables_in_test 592t3 593SHOW CREATE TABLE t3; 594Table Create Table 595t3 CREATE TABLE `t3` ( 596 `c1` bigint NOT NULL 597) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 598ALTER TABLE t3 MODIFY c1 BIGINT UNSIGNED NOT NULL; 599SHOW TABLES; 600Tables_in_test 601t3 602SHOW CREATE TABLE t3; 603Table Create Table 604t3 CREATE TABLE `t3` ( 605 `c1` bigint unsigned 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 NOT NULL); 611SHOW TABLES; 612Tables_in_test 613t3 614SHOW CREATE TABLE t3; 615Table Create Table 616t3 CREATE TABLE `t3` ( 617 `c1` double NOT NULL 618) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 619ALTER TABLE t3 MODIFY c1 REAL UNSIGNED NOT NULL; 620Warnings: 621Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release. 622SHOW TABLES; 623Tables_in_test 624t3 625SHOW CREATE TABLE t3; 626Table Create Table 627t3 CREATE TABLE `t3` ( 628 `c1` double unsigned 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 NOT NULL); 634SHOW TABLES; 635Tables_in_test 636t3 637SHOW CREATE TABLE t3; 638Table Create Table 639t3 CREATE TABLE `t3` ( 640 `c1` double NOT NULL 641) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 642ALTER TABLE t3 MODIFY c1 DOUBLE UNSIGNED NOT NULL; 643Warnings: 644Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release. 645SHOW TABLES; 646Tables_in_test 647t3 648SHOW CREATE TABLE t3; 649Table Create Table 650t3 CREATE TABLE `t3` ( 651 `c1` double unsigned 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 NOT NULL); 657SHOW TABLES; 658Tables_in_test 659t3 660SHOW CREATE TABLE t3; 661Table Create Table 662t3 CREATE TABLE `t3` ( 663 `c1` float NOT NULL 664) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 665ALTER TABLE t3 MODIFY c1 FLOAT UNSIGNED NOT NULL; 666Warnings: 667Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release. 668SHOW TABLES; 669Tables_in_test 670t3 671SHOW CREATE TABLE t3; 672Table Create Table 673t3 CREATE TABLE `t3` ( 674 `c1` float unsigned 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 NOT NULL); 680SHOW TABLES; 681Tables_in_test 682t3 683SHOW CREATE TABLE t3; 684Table Create Table 685t3 CREATE TABLE `t3` ( 686 `c1` decimal(10,0) NOT NULL 687) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 688ALTER TABLE t3 MODIFY c1 DECIMAL UNSIGNED NOT NULL; 689Warnings: 690Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release. 691SHOW TABLES; 692Tables_in_test 693t3 694SHOW CREATE TABLE t3; 695Table Create Table 696t3 CREATE TABLE `t3` ( 697 `c1` decimal(10,0) unsigned 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 NOT NULL); 703SHOW TABLES; 704Tables_in_test 705t3 706SHOW CREATE TABLE t3; 707Table Create Table 708t3 CREATE TABLE `t3` ( 709 `c1` decimal(10,0) NOT NULL 710) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 711ALTER TABLE t3 MODIFY c1 NUMERIC UNSIGNED NOT NULL; 712Warnings: 713Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release. 714SHOW TABLES; 715Tables_in_test 716t3 717SHOW CREATE TABLE t3; 718Table Create Table 719t3 CREATE TABLE `t3` ( 720 `c1` decimal(10,0) unsigned 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 NOT NULL); 726SHOW TABLES; 727Tables_in_test 728t3 729SHOW CREATE TABLE t3; 730Table Create Table 731t3 CREATE TABLE `t3` ( 732 `c1` tinyint NOT NULL 733) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 734ALTER TABLE t3 CHANGE c1 c1 TINYINT UNSIGNED NOT NULL; 735SHOW TABLES; 736Tables_in_test 737t3 738SHOW CREATE TABLE t3; 739Table Create Table 740t3 CREATE TABLE `t3` ( 741 `c1` tinyint unsigned 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 NOT NULL); 747SHOW TABLES; 748Tables_in_test 749t3 750SHOW CREATE TABLE t3; 751Table Create Table 752t3 CREATE TABLE `t3` ( 753 `c1` smallint NOT NULL 754) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 755ALTER TABLE t3 CHANGE c1 c1 SMALLINT UNSIGNED NOT NULL; 756SHOW TABLES; 757Tables_in_test 758t3 759SHOW CREATE TABLE t3; 760Table Create Table 761t3 CREATE TABLE `t3` ( 762 `c1` smallint unsigned 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 NOT NULL); 768SHOW TABLES; 769Tables_in_test 770t3 771SHOW CREATE TABLE t3; 772Table Create Table 773t3 CREATE TABLE `t3` ( 774 `c1` mediumint NOT NULL 775) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 776ALTER TABLE t3 CHANGE c1 c1 MEDIUMINT UNSIGNED NOT NULL; 777SHOW TABLES; 778Tables_in_test 779t3 780SHOW CREATE TABLE t3; 781Table Create Table 782t3 CREATE TABLE `t3` ( 783 `c1` mediumint unsigned 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 NOT NULL); 789SHOW TABLES; 790Tables_in_test 791t3 792SHOW CREATE TABLE t3; 793Table Create Table 794t3 CREATE TABLE `t3` ( 795 `c1` int NOT NULL 796) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 797ALTER TABLE t3 CHANGE c1 c1 INT UNSIGNED NOT NULL; 798SHOW TABLES; 799Tables_in_test 800t3 801SHOW CREATE TABLE t3; 802Table Create Table 803t3 CREATE TABLE `t3` ( 804 `c1` int unsigned 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 NOT NULL); 810SHOW TABLES; 811Tables_in_test 812t3 813SHOW CREATE TABLE t3; 814Table Create Table 815t3 CREATE TABLE `t3` ( 816 `c1` int NOT NULL 817) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 818ALTER TABLE t3 CHANGE c1 c1 INTEGER UNSIGNED NOT NULL; 819SHOW TABLES; 820Tables_in_test 821t3 822SHOW CREATE TABLE t3; 823Table Create Table 824t3 CREATE TABLE `t3` ( 825 `c1` int unsigned 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 NOT NULL); 831SHOW TABLES; 832Tables_in_test 833t3 834SHOW CREATE TABLE t3; 835Table Create Table 836t3 CREATE TABLE `t3` ( 837 `c1` bigint NOT NULL 838) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 839ALTER TABLE t3 CHANGE c1 c1 BIGINT UNSIGNED NOT NULL; 840SHOW TABLES; 841Tables_in_test 842t3 843SHOW CREATE TABLE t3; 844Table Create Table 845t3 CREATE TABLE `t3` ( 846 `c1` bigint unsigned 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 NOT NULL); 852SHOW TABLES; 853Tables_in_test 854t3 855SHOW CREATE TABLE t3; 856Table Create Table 857t3 CREATE TABLE `t3` ( 858 `c1` double NOT NULL 859) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 860ALTER TABLE t3 CHANGE c1 c1 REAL UNSIGNED NOT NULL; 861Warnings: 862Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release. 863SHOW TABLES; 864Tables_in_test 865t3 866SHOW CREATE TABLE t3; 867Table Create Table 868t3 CREATE TABLE `t3` ( 869 `c1` double unsigned 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 NOT NULL); 875SHOW TABLES; 876Tables_in_test 877t3 878SHOW CREATE TABLE t3; 879Table Create Table 880t3 CREATE TABLE `t3` ( 881 `c1` double NOT NULL 882) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 883ALTER TABLE t3 CHANGE c1 c1 DOUBLE UNSIGNED NOT NULL; 884Warnings: 885Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release. 886SHOW TABLES; 887Tables_in_test 888t3 889SHOW CREATE TABLE t3; 890Table Create Table 891t3 CREATE TABLE `t3` ( 892 `c1` double unsigned 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 NOT NULL); 898SHOW TABLES; 899Tables_in_test 900t3 901SHOW CREATE TABLE t3; 902Table Create Table 903t3 CREATE TABLE `t3` ( 904 `c1` float NOT NULL 905) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 906ALTER TABLE t3 CHANGE c1 c1 FLOAT UNSIGNED NOT NULL; 907Warnings: 908Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release. 909SHOW TABLES; 910Tables_in_test 911t3 912SHOW CREATE TABLE t3; 913Table Create Table 914t3 CREATE TABLE `t3` ( 915 `c1` float unsigned 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 NOT NULL); 921SHOW TABLES; 922Tables_in_test 923t3 924SHOW CREATE TABLE t3; 925Table Create Table 926t3 CREATE TABLE `t3` ( 927 `c1` decimal(10,0) NOT NULL 928) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 929ALTER TABLE t3 CHANGE c1 c1 DECIMAL UNSIGNED NOT NULL; 930Warnings: 931Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release. 932SHOW TABLES; 933Tables_in_test 934t3 935SHOW CREATE TABLE t3; 936Table Create Table 937t3 CREATE TABLE `t3` ( 938 `c1` decimal(10,0) unsigned 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 NOT NULL); 944SHOW TABLES; 945Tables_in_test 946t3 947SHOW CREATE TABLE t3; 948Table Create Table 949t3 CREATE TABLE `t3` ( 950 `c1` decimal(10,0) NOT NULL 951) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 952ALTER TABLE t3 CHANGE c1 c1 NUMERIC UNSIGNED NOT NULL; 953Warnings: 954Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release. 955SHOW TABLES; 956Tables_in_test 957t3 958SHOW CREATE TABLE t3; 959Table Create Table 960t3 CREATE TABLE `t3` ( 961 `c1` decimal(10,0) unsigned NOT NULL 962) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 963DROP TABLE t3; 964SHOW TABLES; 965Tables_in_test 966