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 11DROP TABLE t3; 12SHOW TABLES; 13Tables_in_test 14CREATE TABLE t3(c1 SMALLINT UNSIGNED NULL); 15SHOW TABLES; 16Tables_in_test 17t3 18SHOW CREATE TABLE t3; 19Table Create Table 20t3 CREATE TABLE `t3` ( 21 `c1` smallint unsigned DEFAULT NULL 22) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 23DROP TABLE t3; 24SHOW TABLES; 25Tables_in_test 26CREATE TABLE t3(c1 MEDIUMINT UNSIGNED NULL); 27SHOW TABLES; 28Tables_in_test 29t3 30SHOW CREATE TABLE t3; 31Table Create Table 32t3 CREATE TABLE `t3` ( 33 `c1` mediumint unsigned DEFAULT NULL 34) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 35DROP TABLE t3; 36SHOW TABLES; 37Tables_in_test 38CREATE TABLE t3(c1 INT UNSIGNED NULL); 39SHOW TABLES; 40Tables_in_test 41t3 42SHOW CREATE TABLE t3; 43Table Create Table 44t3 CREATE TABLE `t3` ( 45 `c1` int unsigned DEFAULT NULL 46) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 47DROP TABLE t3; 48SHOW TABLES; 49Tables_in_test 50CREATE TABLE t3(c1 INTEGER UNSIGNED NULL); 51SHOW TABLES; 52Tables_in_test 53t3 54SHOW CREATE TABLE t3; 55Table Create Table 56t3 CREATE TABLE `t3` ( 57 `c1` int unsigned DEFAULT NULL 58) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 59DROP TABLE t3; 60SHOW TABLES; 61Tables_in_test 62CREATE TABLE t3(c1 BIGINT UNSIGNED NULL); 63SHOW TABLES; 64Tables_in_test 65t3 66SHOW CREATE TABLE t3; 67Table Create Table 68t3 CREATE TABLE `t3` ( 69 `c1` bigint unsigned DEFAULT NULL 70) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 71DROP TABLE t3; 72SHOW TABLES; 73Tables_in_test 74CREATE TABLE t3(c1 DECIMAL UNSIGNED NULL); 75Warnings: 76Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release. 77SHOW TABLES; 78Tables_in_test 79t3 80SHOW CREATE TABLE t3; 81Table Create Table 82t3 CREATE TABLE `t3` ( 83 `c1` decimal(10,0) unsigned DEFAULT NULL 84) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 85DROP TABLE t3; 86SHOW TABLES; 87Tables_in_test 88CREATE TABLE t3(c1 DEC UNSIGNED NULL); 89Warnings: 90Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release. 91SHOW TABLES; 92Tables_in_test 93t3 94SHOW CREATE TABLE t3; 95Table Create Table 96t3 CREATE TABLE `t3` ( 97 `c1` decimal(10,0) unsigned DEFAULT NULL 98) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 99DROP TABLE t3; 100SHOW TABLES; 101Tables_in_test 102CREATE TABLE t3(c1 FIXED UNSIGNED NULL); 103Warnings: 104Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release. 105SHOW TABLES; 106Tables_in_test 107t3 108SHOW CREATE TABLE t3; 109Table Create Table 110t3 CREATE TABLE `t3` ( 111 `c1` decimal(10,0) unsigned DEFAULT NULL 112) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 113DROP TABLE t3; 114SHOW TABLES; 115Tables_in_test 116CREATE TABLE t3(c1 NUMERIC UNSIGNED NULL); 117Warnings: 118Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release. 119SHOW TABLES; 120Tables_in_test 121t3 122SHOW CREATE TABLE t3; 123Table Create Table 124t3 CREATE TABLE `t3` ( 125 `c1` decimal(10,0) unsigned DEFAULT NULL 126) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 127DROP TABLE t3; 128SHOW TABLES; 129Tables_in_test 130CREATE TABLE t3(c1 DOUBLE UNSIGNED NULL); 131Warnings: 132Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release. 133SHOW TABLES; 134Tables_in_test 135t3 136SHOW CREATE TABLE t3; 137Table Create Table 138t3 CREATE TABLE `t3` ( 139 `c1` double unsigned DEFAULT NULL 140) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 141DROP TABLE t3; 142SHOW TABLES; 143Tables_in_test 144CREATE TABLE t3(c1 REAL UNSIGNED NULL); 145Warnings: 146Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release. 147SHOW TABLES; 148Tables_in_test 149t3 150SHOW CREATE TABLE t3; 151Table Create Table 152t3 CREATE TABLE `t3` ( 153 `c1` double unsigned DEFAULT NULL 154) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 155DROP TABLE t3; 156SHOW TABLES; 157Tables_in_test 158CREATE TABLE t3(c1 DOUBLE PRECISION UNSIGNED NULL); 159Warnings: 160Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release. 161SHOW TABLES; 162Tables_in_test 163t3 164SHOW CREATE TABLE t3; 165Table Create Table 166t3 CREATE TABLE `t3` ( 167 `c1` double unsigned DEFAULT NULL 168) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 169DROP TABLE t3; 170SHOW TABLES; 171Tables_in_test 172CREATE TABLE t3(c1 FLOAT UNSIGNED NULL); 173Warnings: 174Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release. 175SHOW TABLES; 176Tables_in_test 177t3 178SHOW CREATE TABLE t3; 179Table Create Table 180t3 CREATE TABLE `t3` ( 181 `c1` float unsigned DEFAULT NULL 182) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 183DROP TABLE t3; 184SHOW TABLES; 185Tables_in_test 186CREATE TABLE t3(c1 TINYINT UNSIGNED NOT NULL); 187SHOW TABLES; 188Tables_in_test 189t3 190SHOW CREATE TABLE t3; 191Table Create Table 192t3 CREATE TABLE `t3` ( 193 `c1` tinyint unsigned NOT NULL 194) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 195DROP TABLE t3; 196SHOW TABLES; 197Tables_in_test 198CREATE TABLE t3(c1 SMALLINT UNSIGNED NOT NULL); 199SHOW TABLES; 200Tables_in_test 201t3 202SHOW CREATE TABLE t3; 203Table Create Table 204t3 CREATE TABLE `t3` ( 205 `c1` smallint unsigned NOT NULL 206) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 207DROP TABLE t3; 208SHOW TABLES; 209Tables_in_test 210CREATE TABLE t3(c1 MEDIUMINT UNSIGNED NOT NULL); 211SHOW TABLES; 212Tables_in_test 213t3 214SHOW CREATE TABLE t3; 215Table Create Table 216t3 CREATE TABLE `t3` ( 217 `c1` mediumint unsigned NOT NULL 218) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 219DROP TABLE t3; 220SHOW TABLES; 221Tables_in_test 222CREATE TABLE t3(c1 INT UNSIGNED NOT NULL); 223SHOW TABLES; 224Tables_in_test 225t3 226SHOW CREATE TABLE t3; 227Table Create Table 228t3 CREATE TABLE `t3` ( 229 `c1` int unsigned NOT NULL 230) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 231DROP TABLE t3; 232SHOW TABLES; 233Tables_in_test 234CREATE TABLE t3(c1 INTEGER UNSIGNED NOT NULL); 235SHOW TABLES; 236Tables_in_test 237t3 238SHOW CREATE TABLE t3; 239Table Create Table 240t3 CREATE TABLE `t3` ( 241 `c1` int unsigned NOT NULL 242) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 243DROP TABLE t3; 244SHOW TABLES; 245Tables_in_test 246CREATE TABLE t3(c1 BIGINT UNSIGNED NOT NULL); 247SHOW TABLES; 248Tables_in_test 249t3 250SHOW CREATE TABLE t3; 251Table Create Table 252t3 CREATE TABLE `t3` ( 253 `c1` bigint unsigned NOT NULL 254) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 255DROP TABLE t3; 256SHOW TABLES; 257Tables_in_test 258CREATE TABLE t3(c1 DECIMAL UNSIGNED NOT NULL); 259Warnings: 260Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release. 261SHOW TABLES; 262Tables_in_test 263t3 264SHOW CREATE TABLE t3; 265Table Create Table 266t3 CREATE TABLE `t3` ( 267 `c1` decimal(10,0) unsigned NOT NULL 268) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 269DROP TABLE t3; 270SHOW TABLES; 271Tables_in_test 272CREATE TABLE t3(c1 DEC UNSIGNED NOT NULL); 273Warnings: 274Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release. 275SHOW TABLES; 276Tables_in_test 277t3 278SHOW CREATE TABLE t3; 279Table Create Table 280t3 CREATE TABLE `t3` ( 281 `c1` decimal(10,0) unsigned NOT NULL 282) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 283DROP TABLE t3; 284SHOW TABLES; 285Tables_in_test 286CREATE TABLE t3(c1 FIXED UNSIGNED NOT NULL); 287Warnings: 288Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release. 289SHOW TABLES; 290Tables_in_test 291t3 292SHOW CREATE TABLE t3; 293Table Create Table 294t3 CREATE TABLE `t3` ( 295 `c1` decimal(10,0) unsigned NOT NULL 296) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 297DROP TABLE t3; 298SHOW TABLES; 299Tables_in_test 300CREATE TABLE t3(c1 NUMERIC UNSIGNED NOT NULL); 301Warnings: 302Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release. 303SHOW TABLES; 304Tables_in_test 305t3 306SHOW CREATE TABLE t3; 307Table Create Table 308t3 CREATE TABLE `t3` ( 309 `c1` decimal(10,0) unsigned NOT NULL 310) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 311DROP TABLE t3; 312SHOW TABLES; 313Tables_in_test 314CREATE TABLE t3(c1 DOUBLE UNSIGNED NOT NULL); 315Warnings: 316Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release. 317SHOW TABLES; 318Tables_in_test 319t3 320SHOW CREATE TABLE t3; 321Table Create Table 322t3 CREATE TABLE `t3` ( 323 `c1` double unsigned NOT NULL 324) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 325DROP TABLE t3; 326SHOW TABLES; 327Tables_in_test 328CREATE TABLE t3(c1 REAL UNSIGNED NOT NULL); 329Warnings: 330Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release. 331SHOW TABLES; 332Tables_in_test 333t3 334SHOW CREATE TABLE t3; 335Table Create Table 336t3 CREATE TABLE `t3` ( 337 `c1` double unsigned NOT NULL 338) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 339DROP TABLE t3; 340SHOW TABLES; 341Tables_in_test 342CREATE TABLE t3(c1 DOUBLE PRECISION UNSIGNED NOT NULL); 343Warnings: 344Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release. 345SHOW TABLES; 346Tables_in_test 347t3 348SHOW CREATE TABLE t3; 349Table Create Table 350t3 CREATE TABLE `t3` ( 351 `c1` double unsigned NOT NULL 352) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 353DROP TABLE t3; 354SHOW TABLES; 355Tables_in_test 356CREATE TABLE t3(c1 FLOAT UNSIGNED NOT NULL); 357Warnings: 358Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release. 359SHOW TABLES; 360Tables_in_test 361t3 362SHOW CREATE TABLE t3; 363Table Create Table 364t3 CREATE TABLE `t3` ( 365 `c1` float unsigned NOT NULL 366) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 367DROP TABLE t3; 368SHOW TABLES; 369Tables_in_test 370