Debian Codegraph @

mysql-test/suite/engines/funcs/r/tc_column_enum.result

raw
1 DROP TABLE IF EXISTS t6;
2 CREATE TABLE t6(c1 ENUM('a','b','c') NULL);
3 SHOW TABLES;
4 Tables_in_test
5 t6
6 SHOW CREATE TABLE t6;
7 Table Create Table
8 t6 CREATE TABLE `t6` (
9 `c1` enum('a','b','c') DEFAULT NULL
10 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
11 DROP TABLE t6;
12 SHOW TABLES;
13 Tables_in_test
14 CREATE TABLE t6(c1 ENUM('a','b','c') NOT NULL);
15 SHOW TABLES;
16 Tables_in_test
17 t6
18 SHOW CREATE TABLE t6;
19 Table Create Table
20 t6 CREATE TABLE `t6` (
21 `c1` enum('a','b','c') NOT NULL
22 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
23 DROP TABLE t6;
24 SHOW TABLES;
25 Tables_in_test