1DROP TABLE IF EXISTS t11; 2CREATE TABLE t11(c1 TINYINT(5) NULL DEFAULT 1); 3Warnings: 4Warning 1681 Integer display width is deprecated and will be removed in a future release. 5SHOW TABLES; 6Tables_in_test 7t11 8SHOW CREATE TABLE t11; 9Table Create Table 10t11 CREATE TABLE `t11` ( 11 `c1` tinyint DEFAULT '1' 12) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 13DROP TABLE t11; 14SHOW TABLES; 15Tables_in_test 16CREATE TABLE t11(c1 SMALLINT(5) NULL DEFAULT 1); 17Warnings: 18Warning 1681 Integer display width is deprecated and will be removed in a future release. 19SHOW TABLES; 20Tables_in_test 21t11 22SHOW CREATE TABLE t11; 23Table Create Table 24t11 CREATE TABLE `t11` ( 25 `c1` smallint DEFAULT '1' 26) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 27DROP TABLE t11; 28SHOW TABLES; 29Tables_in_test 30CREATE TABLE t11(c1 MEDIUMINT(5) NULL DEFAULT 1); 31Warnings: 32Warning 1681 Integer display width is deprecated and will be removed in a future release. 33SHOW TABLES; 34Tables_in_test 35t11 36SHOW CREATE TABLE t11; 37Table Create Table 38t11 CREATE TABLE `t11` ( 39 `c1` mediumint DEFAULT '1' 40) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 41DROP TABLE t11; 42SHOW TABLES; 43Tables_in_test 44CREATE TABLE t11(c1 INT(5) NULL DEFAULT 1); 45Warnings: 46Warning 1681 Integer display width is deprecated and will be removed in a future release. 47SHOW TABLES; 48Tables_in_test 49t11 50SHOW CREATE TABLE t11; 51Table Create Table 52t11 CREATE TABLE `t11` ( 53 `c1` int DEFAULT '1' 54) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 55DROP TABLE t11; 56SHOW TABLES; 57Tables_in_test 58CREATE TABLE t11(c1 INTEGER(5) NULL DEFAULT 1); 59Warnings: 60Warning 1681 Integer display width is deprecated and will be removed in a future release. 61SHOW TABLES; 62Tables_in_test 63t11 64SHOW CREATE TABLE t11; 65Table Create Table 66t11 CREATE TABLE `t11` ( 67 `c1` int DEFAULT '1' 68) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 69DROP TABLE t11; 70SHOW TABLES; 71Tables_in_test 72CREATE TABLE t11(c1 BIGINT(5) NULL DEFAULT 1); 73Warnings: 74Warning 1681 Integer display width is deprecated and will be removed in a future release. 75SHOW TABLES; 76Tables_in_test 77t11 78SHOW CREATE TABLE t11; 79Table Create Table 80t11 CREATE TABLE `t11` ( 81 `c1` bigint DEFAULT '1' 82) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 83DROP TABLE t11; 84SHOW TABLES; 85Tables_in_test 86CREATE TABLE t11(c1 TINYINT(5) NOT NULL DEFAULT 1); 87Warnings: 88Warning 1681 Integer display width is deprecated and will be removed in a future release. 89SHOW TABLES; 90Tables_in_test 91t11 92SHOW CREATE TABLE t11; 93Table Create Table 94t11 CREATE TABLE `t11` ( 95 `c1` tinyint NOT NULL DEFAULT '1' 96) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 97DROP TABLE t11; 98SHOW TABLES; 99Tables_in_test 100CREATE TABLE t11(c1 SMALLINT(5) NOT NULL DEFAULT 1); 101Warnings: 102Warning 1681 Integer display width is deprecated and will be removed in a future release. 103SHOW TABLES; 104Tables_in_test 105t11 106SHOW CREATE TABLE t11; 107Table Create Table 108t11 CREATE TABLE `t11` ( 109 `c1` smallint NOT NULL DEFAULT '1' 110) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 111DROP TABLE t11; 112SHOW TABLES; 113Tables_in_test 114CREATE TABLE t11(c1 MEDIUMINT(5) NOT NULL DEFAULT 1); 115Warnings: 116Warning 1681 Integer display width is deprecated and will be removed in a future release. 117SHOW TABLES; 118Tables_in_test 119t11 120SHOW CREATE TABLE t11; 121Table Create Table 122t11 CREATE TABLE `t11` ( 123 `c1` mediumint NOT NULL DEFAULT '1' 124) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 125DROP TABLE t11; 126SHOW TABLES; 127Tables_in_test 128CREATE TABLE t11(c1 INT(5) NOT NULL DEFAULT 1); 129Warnings: 130Warning 1681 Integer display width is deprecated and will be removed in a future release. 131SHOW TABLES; 132Tables_in_test 133t11 134SHOW CREATE TABLE t11; 135Table Create Table 136t11 CREATE TABLE `t11` ( 137 `c1` int NOT NULL DEFAULT '1' 138) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 139DROP TABLE t11; 140SHOW TABLES; 141Tables_in_test 142CREATE TABLE t11(c1 INTEGER(5) NOT NULL DEFAULT 1); 143Warnings: 144Warning 1681 Integer display width is deprecated and will be removed in a future release. 145SHOW TABLES; 146Tables_in_test 147t11 148SHOW CREATE TABLE t11; 149Table Create Table 150t11 CREATE TABLE `t11` ( 151 `c1` int NOT NULL DEFAULT '1' 152) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 153DROP TABLE t11; 154SHOW TABLES; 155Tables_in_test 156CREATE TABLE t11(c1 BIGINT(5) NOT NULL DEFAULT 1); 157Warnings: 158Warning 1681 Integer display width is deprecated and will be removed in a future release. 159SHOW TABLES; 160Tables_in_test 161t11 162SHOW CREATE TABLE t11; 163Table Create Table 164t11 CREATE TABLE `t11` ( 165 `c1` bigint NOT NULL DEFAULT '1' 166) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 167DROP TABLE t11; 168SHOW TABLES; 169Tables_in_test 170