Debian Codegraph @

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

raw
1 DROP TABLE IF EXISTS t8;
2 CREATE TABLE t8(c1 TINYINT NOT NULL AUTO_INCREMENT PRIMARY KEY);
3 SHOW TABLES;
4 Tables_in_test
5 t8
6 SHOW CREATE TABLE t8;
7 Table Create Table
8 t8 CREATE TABLE `t8` (
9 `c1` tinyint NOT NULL AUTO_INCREMENT,
10 PRIMARY KEY (`c1`)
11 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
12 DROP TABLE t8;
13 SHOW TABLES;
14 Tables_in_test
15 CREATE TABLE t8(c1 SMALLINT NOT NULL AUTO_INCREMENT PRIMARY KEY);
16 SHOW TABLES;
17 Tables_in_test
18 t8
19 SHOW CREATE TABLE t8;
20 Table Create Table
21 t8 CREATE TABLE `t8` (
22 `c1` smallint NOT NULL AUTO_INCREMENT,
23 PRIMARY KEY (`c1`)
24 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
25 DROP TABLE t8;
26 SHOW TABLES;
27 Tables_in_test
28 CREATE TABLE t8(c1 MEDIUMINT NOT NULL AUTO_INCREMENT PRIMARY KEY);
29 SHOW TABLES;
30 Tables_in_test
31 t8
32 SHOW CREATE TABLE t8;
33 Table Create Table
34 t8 CREATE TABLE `t8` (
35 `c1` mediumint NOT NULL AUTO_INCREMENT,
36 PRIMARY KEY (`c1`)
37 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
38 DROP TABLE t8;
39 SHOW TABLES;
40 Tables_in_test
41 CREATE TABLE t8(c1 INT NOT NULL AUTO_INCREMENT PRIMARY KEY);
42 SHOW TABLES;
43 Tables_in_test
44 t8
45 SHOW CREATE TABLE t8;
46 Table Create Table
47 t8 CREATE TABLE `t8` (
48 `c1` int NOT NULL AUTO_INCREMENT,
49 PRIMARY KEY (`c1`)
50 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
51 DROP TABLE t8;
52 SHOW TABLES;
53 Tables_in_test
54 CREATE TABLE t8(c1 INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY);
55 SHOW TABLES;
56 Tables_in_test
57 t8
58 SHOW CREATE TABLE t8;
59 Table Create Table
60 t8 CREATE TABLE `t8` (
61 `c1` int NOT NULL AUTO_INCREMENT,
62 PRIMARY KEY (`c1`)
63 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
64 DROP TABLE t8;
65 SHOW TABLES;
66 Tables_in_test
67 CREATE TABLE t8(c1 BIGINT NOT NULL AUTO_INCREMENT PRIMARY KEY);
68 SHOW TABLES;
69 Tables_in_test
70 t8
71 SHOW CREATE TABLE t8;
72 Table Create Table
73 t8 CREATE TABLE `t8` (
74 `c1` bigint NOT NULL AUTO_INCREMENT,
75 PRIMARY KEY (`c1`)
76 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
77 DROP TABLE t8;
78 SHOW TABLES;
79 Tables_in_test