Debian Codegraph @

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

raw
1 DROP TABLE IF EXISTS t1;
2 CREATE TABLE t1(c1 CHAR(10) NULL COMMENT 'This is 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 COMMENT 'This is a CHAR column'
10 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
11 DROP TABLE t1;
12 SHOW TABLES;
13 Tables_in_test
14 CREATE TABLE t1(c1 VARCHAR(10) NULL COMMENT 'This is 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 COMMENT 'This is a VARCHAR column'
22 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
23 DROP TABLE t1;
24 SHOW TABLES;
25 Tables_in_test
26 CREATE TABLE t1(c1 BINARY(10) NULL COMMENT 'This is 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 COMMENT 'This is a BINARY column'
34 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
35 DROP TABLE t1;
36 SHOW TABLES;
37 Tables_in_test
38 CREATE TABLE t1(c1 VARBINARY(10) NULL COMMENT 'This is 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 COMMENT 'This is a VARBINARY column'
46 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
47 DROP TABLE t1;
48 SHOW TABLES;
49 Tables_in_test