Debian Codegraph @

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

raw
1 DROP TABLE IF EXISTS t1;
2 CREATE TABLE t1(c1 CHAR(10) NULL) COMMENT = 'This table has a CHAR column';
3 SHOW TABLES;
4 Tables_in_test
5 t1
6 SHOW CREATE TABLE t1;
7 Table Create Table
8 t1 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'
11 DROP TABLE t1;
12 SHOW TABLES;
13 Tables_in_test
14 CREATE TABLE t1(c1 VARCHAR(10) NULL) COMMENT = 'This table has a VARCHAR column';
15 SHOW TABLES;
16 Tables_in_test
17 t1
18 SHOW CREATE TABLE t1;
19 Table Create Table
20 t1 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'
23 DROP TABLE t1;
24 SHOW TABLES;
25 Tables_in_test
26 CREATE TABLE t1(c1 BINARY(10) NULL) COMMENT = 'This table has a BINARY column';
27 SHOW TABLES;
28 Tables_in_test
29 t1
30 SHOW CREATE TABLE t1;
31 Table Create Table
32 t1 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'
35 DROP TABLE t1;
36 SHOW TABLES;
37 Tables_in_test
38 CREATE TABLE t1(c1 VARBINARY(10) NULL) COMMENT = 'This table has a VARBINARY column';
39 SHOW TABLES;
40 Tables_in_test
41 t1
42 SHOW CREATE TABLE t1;
43 Table Create Table
44 t1 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'
47 DROP TABLE t1;
48 SHOW TABLES;
49 Tables_in_test