1DROP TABLE IF EXISTS t9; 2CREATE TABLE t9(c1 CHAR(10) NOT NULL KEY); 3SHOW TABLES; 4Tables_in_test 5t9 6SHOW CREATE TABLE t9; 7Table Create Table 8t9 CREATE TABLE `t9` ( 9 `c1` char(10) NOT NULL, 10 PRIMARY KEY (`c1`) 11) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 12DROP TABLE t9; 13SHOW TABLES; 14Tables_in_test 15CREATE TABLE t9(c1 VARCHAR(10) NOT NULL KEY); 16SHOW TABLES; 17Tables_in_test 18t9 19SHOW CREATE TABLE t9; 20Table Create Table 21t9 CREATE TABLE `t9` ( 22 `c1` varchar(10) NOT NULL, 23 PRIMARY KEY (`c1`) 24) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 25DROP TABLE t9; 26SHOW TABLES; 27Tables_in_test 28CREATE TABLE t9(c1 BINARY(10) NOT NULL KEY); 29SHOW TABLES; 30Tables_in_test 31t9 32SHOW CREATE TABLE t9; 33Table Create Table 34t9 CREATE TABLE `t9` ( 35 `c1` binary(10) NOT NULL, 36 PRIMARY KEY (`c1`) 37) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 38DROP TABLE t9; 39SHOW TABLES; 40Tables_in_test 41CREATE TABLE t9(c1 VARBINARY(10) NOT NULL KEY); 42SHOW TABLES; 43Tables_in_test 44t9 45SHOW CREATE TABLE t9; 46Table Create Table 47t9 CREATE TABLE `t9` ( 48 `c1` varbinary(10) NOT NULL, 49 PRIMARY KEY (`c1`) 50) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 51DROP TABLE t9; 52SHOW TABLES; 53Tables_in_test 54