Debian Codegraph @

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

raw
1 DROP TABLE IF EXISTS src,dest;
2 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 CHAR(10) NULL, PRIMARY KEY(c1));
3 CREATE TABLE dst LIKE src;
4 SHOW TABLES;
5 Tables_in_test
6 dst
7 src
8 SHOW CREATE TABLE dst;
9 Table Create Table
10 dst CREATE TABLE `dst` (
11 `c1` int NOT NULL AUTO_INCREMENT,
12 `c2` char(10) DEFAULT NULL,
13 PRIMARY KEY (`c1`)
14 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
15 DROP TABLE dst;
16 SHOW TABLES;
17 Tables_in_test
18 src
19 DROP TABLE src;
20 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 VARCHAR(10) NULL, PRIMARY KEY(c1));
21 CREATE TABLE dst LIKE src;
22 SHOW TABLES;
23 Tables_in_test
24 dst
25 src
26 SHOW CREATE TABLE dst;
27 Table Create Table
28 dst CREATE TABLE `dst` (
29 `c1` int NOT NULL AUTO_INCREMENT,
30 `c2` varchar(10) DEFAULT NULL,
31 PRIMARY KEY (`c1`)
32 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
33 DROP TABLE dst;
34 SHOW TABLES;
35 Tables_in_test
36 src
37 DROP TABLE src;
38 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 BINARY(10) NULL, PRIMARY KEY(c1));
39 CREATE TABLE dst LIKE src;
40 SHOW TABLES;
41 Tables_in_test
42 dst
43 src
44 SHOW CREATE TABLE dst;
45 Table Create Table
46 dst CREATE TABLE `dst` (
47 `c1` int NOT NULL AUTO_INCREMENT,
48 `c2` binary(10) DEFAULT NULL,
49 PRIMARY KEY (`c1`)
50 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
51 DROP TABLE dst;
52 SHOW TABLES;
53 Tables_in_test
54 src
55 DROP TABLE src;
56 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 VARBINARY(10) NULL, PRIMARY KEY(c1));
57 CREATE TABLE dst LIKE src;
58 SHOW TABLES;
59 Tables_in_test
60 dst
61 src
62 SHOW CREATE TABLE dst;
63 Table Create Table
64 dst CREATE TABLE `dst` (
65 `c1` int NOT NULL AUTO_INCREMENT,
66 `c2` varbinary(10) DEFAULT NULL,
67 PRIMARY KEY (`c1`)
68 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
69 DROP TABLE dst;
70 SHOW TABLES;
71 Tables_in_test
72 src
73 DROP TABLE src;