1DROP TABLE IF EXISTS t2; 2CREATE TABLE t2(c1 CHAR(50) NULL); 3CREATE UNIQUE INDEX i1 ON t2(c1); 4SHOW TABLES; 5Tables_in_test 6t2 7SHOW CREATE TABLE t2; 8Table Create Table 9t2 CREATE TABLE `t2` ( 10 `c1` char(50) DEFAULT NULL, 11 UNIQUE KEY `i1` (`c1`) 12) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 13DROP TABLE t2; 14SHOW TABLES; 15Tables_in_test 16CREATE TABLE t2(c1 VARCHAR(50) NULL); 17CREATE UNIQUE INDEX i1 ON t2(c1); 18SHOW TABLES; 19Tables_in_test 20t2 21SHOW CREATE TABLE t2; 22Table Create Table 23t2 CREATE TABLE `t2` ( 24 `c1` varchar(50) DEFAULT NULL, 25 UNIQUE KEY `i1` (`c1`) 26) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 27DROP TABLE t2; 28SHOW TABLES; 29Tables_in_test 30CREATE TABLE t2(c1 BINARY(50) NULL); 31CREATE UNIQUE INDEX i1 ON t2(c1); 32SHOW TABLES; 33Tables_in_test 34t2 35SHOW CREATE TABLE t2; 36Table Create Table 37t2 CREATE TABLE `t2` ( 38 `c1` binary(50) DEFAULT NULL, 39 UNIQUE KEY `i1` (`c1`) 40) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 41DROP TABLE t2; 42SHOW TABLES; 43Tables_in_test 44CREATE TABLE t2(c1 VARBINARY(50) NULL); 45CREATE UNIQUE INDEX i1 ON t2(c1); 46SHOW TABLES; 47Tables_in_test 48t2 49SHOW CREATE TABLE t2; 50Table Create Table 51t2 CREATE TABLE `t2` ( 52 `c1` varbinary(50) DEFAULT NULL, 53 UNIQUE KEY `i1` (`c1`) 54) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 55DROP TABLE t2; 56SHOW TABLES; 57Tables_in_test 58CREATE TABLE t2(c1 CHAR(50) NOT NULL); 59CREATE UNIQUE INDEX i1 ON t2(c1); 60SHOW TABLES; 61Tables_in_test 62t2 63SHOW CREATE TABLE t2; 64Table Create Table 65t2 CREATE TABLE `t2` ( 66 `c1` char(50) NOT NULL, 67 UNIQUE KEY `i1` (`c1`) 68) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 69DROP TABLE t2; 70SHOW TABLES; 71Tables_in_test 72CREATE TABLE t2(c1 VARCHAR(50) NOT NULL); 73CREATE UNIQUE INDEX i1 ON t2(c1); 74SHOW TABLES; 75Tables_in_test 76t2 77SHOW CREATE TABLE t2; 78Table Create Table 79t2 CREATE TABLE `t2` ( 80 `c1` varchar(50) NOT NULL, 81 UNIQUE KEY `i1` (`c1`) 82) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 83DROP TABLE t2; 84SHOW TABLES; 85Tables_in_test 86CREATE TABLE t2(c1 BINARY(50) NOT NULL); 87CREATE UNIQUE INDEX i1 ON t2(c1); 88SHOW TABLES; 89Tables_in_test 90t2 91SHOW CREATE TABLE t2; 92Table Create Table 93t2 CREATE TABLE `t2` ( 94 `c1` binary(50) NOT NULL, 95 UNIQUE KEY `i1` (`c1`) 96) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 97DROP TABLE t2; 98SHOW TABLES; 99Tables_in_test 100CREATE TABLE t2(c1 VARBINARY(50) NOT NULL); 101CREATE UNIQUE INDEX i1 ON t2(c1); 102SHOW TABLES; 103Tables_in_test 104t2 105SHOW CREATE TABLE t2; 106Table Create Table 107t2 CREATE TABLE `t2` ( 108 `c1` varbinary(50) NOT NULL, 109 UNIQUE KEY `i1` (`c1`) 110) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 111DROP TABLE t2; 112SHOW TABLES; 113Tables_in_test 114