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