Debian Codegraph @

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

raw
1 DROP TABLE IF EXISTS t1,t2;
2 CREATE TABLE t1(c1 INTEGER NULL);
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` int DEFAULT NULL
10 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
11 RENAME TABLE t1 TO t2;
12 SHOW TABLES;
13 Tables_in_test
14 t2
15 SHOW CREATE TABLE t2;
16 Table Create Table
17 t2 CREATE TABLE `t2` (
18 `c1` int DEFAULT NULL
19 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
20 DROP TABLE t2;
21 SHOW TABLES;
22 Tables_in_test