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