Debian Codegraph @

mysql-test/suite/storage_engine/autoincrement.result

raw
1 DROP TABLE IF EXISTS t1;
2 CREATE TABLE t1 (a <INT_COLUMN> AUTO_INCREMENT, b <CHAR_COLUMN>, <CUSTOM_INDEX>(a)) ENGINE=<STORAGE_ENGINE> <CUSTOM_TABLE_OPTIONS>;
3 SHOW CREATE TABLE t1;
4 Table Create Table
5 t1 CREATE TABLE `t1` (
6 `a` int(11) NOT NULL AUTO_INCREMENT,
7 `b` char(8) DEFAULT NULL,
8 KEY `a` (`a`)
9 ) ENGINE=<STORAGE_ENGINE> DEFAULT CHARSET=latin1
10 INSERT INTO t1 (b) VALUES ('a'),('b');
11 SELECT a,b FROM t1 ORDER BY a;
12 a b
13 1 a
14 2 b
15 SELECT LAST_INSERT_ID();
16 LAST_INSERT_ID()
17 1
18 INSERT INTO t1 (a,b) VALUES (NULL,'c'),(0,'d');
19 SELECT a,b FROM t1 ORDER BY a;
20 a b
21 1 a
22 2 b
23 3 c
24 4 d
25 SELECT LAST_INSERT_ID();
26 LAST_INSERT_ID()
27 3
28 SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';
29 INSERT INTO t1 (a,b) VALUES (NULL,'e');
30 SELECT a,b FROM t1 ORDER BY a;
31 a b
32 1 a
33 2 b
34 3 c
35 4 d
36 5 e
37 SELECT LAST_INSERT_ID();
38 LAST_INSERT_ID()
39 5
40 INSERT INTO t1 (a,b) VALUES (0,'f');
41 SELECT a,b FROM t1 ORDER BY a;
42 a b
43 0 f
44 1 a
45 2 b
46 3 c
47 4 d
48 5 e
49 SELECT LAST_INSERT_ID();
50 LAST_INSERT_ID()
51 5
52 SET sql_mode = '<INITIAL_SQL_MODE>';
53 SHOW TABLE STATUS FROM test LIKE 't1';
54 Name Engine Version Row_format Rows Avg_row_length Data_length Max_data_length Index_length Data_free Auto_increment Create_time Update_time Check_time Collation Checksum Create_options Comment Max_index_length Temporary
55 t1 <STORAGE_ENGINE> # # # # # # # # 6 # # # # # # # # N
56 INSERT INTO t1 (a,b) VALUES (6,'g'),(7,'h');
57 SELECT LAST_INSERT_ID();
58 LAST_INSERT_ID()
59 5
60 SHOW TABLE STATUS FROM test LIKE 't1';
61 Name Engine Version Row_format Rows Avg_row_length Data_length Max_data_length Index_length Data_free Auto_increment Create_time Update_time Check_time Collation Checksum Create_options Comment Max_index_length Temporary
62 t1 # # # # # # # # # 8 # # # # # # # # N
63 INSERT INTO t1 (a,b) VALUES (NULL,'i'),(9,'j');
64 SELECT a,b FROM t1 ORDER BY a;
65 a b
66 0 f
67 1 a
68 2 b
69 3 c
70 4 d
71 5 e
72 6 g
73 7 h
74 8 i
75 9 j
76 SELECT LAST_INSERT_ID();
77 LAST_INSERT_ID()
78 8
79 SHOW TABLE STATUS FROM test LIKE 't1';
80 Name Engine Version Row_format Rows Avg_row_length Data_length Max_data_length Index_length Data_free Auto_increment Create_time Update_time Check_time Collation Checksum Create_options Comment Max_index_length Temporary
81 t1 # # # # # # # # # 10 # # # # # # # # N
82 INSERT INTO t1 (a,b) VALUES (20,'k');
83 SHOW TABLE STATUS FROM test LIKE 't1';
84 Name Engine Version Row_format Rows Avg_row_length Data_length Max_data_length Index_length Data_free Auto_increment Create_time Update_time Check_time Collation Checksum Create_options Comment Max_index_length Temporary
85 t1 # # # # # # # # # 21 # # # # # # # # N
86 INSERT INTO t1 (a,b) VALUES (NULL,'l');
87 SELECT a,b FROM t1 ORDER BY a;
88 a b
89 0 f
90 1 a
91 2 b
92 3 c
93 4 d
94 5 e
95 6 g
96 7 h
97 8 i
98 9 j
99 20 k
100 21 l
101 SELECT LAST_INSERT_ID();
102 LAST_INSERT_ID()
103 21
104 SHOW TABLE STATUS FROM test LIKE 't1';
105 Name Engine Version Row_format Rows Avg_row_length Data_length Max_data_length Index_length Data_free Auto_increment Create_time Update_time Check_time Collation Checksum Create_options Comment Max_index_length Temporary
106 t1 # # # # # # # # # 22 # # # # # # # # N
107 INSERT INTO t1 (a,b) VALUES (-5,'m');
108 SELECT a,b FROM t1 ORDER BY a;
109 a b
110 -5 m
111 0 f
112 1 a
113 2 b
114 3 c
115 4 d
116 5 e
117 6 g
118 7 h
119 8 i
120 9 j
121 20 k
122 21 l
123 DROP TABLE t1;
124 CREATE TABLE t1 (a <INT_COLUMN> AUTO_INCREMENT, b <CHAR_COLUMN>, <CUSTOM_INDEX>(a)) ENGINE=<STORAGE_ENGINE> <CUSTOM_TABLE_OPTIONS> AUTO_INCREMENT = 100;
125 INSERT INTO t1 (a,b) VALUES (NULL,'a'),(NULL,'b');
126 SELECT a,b FROM t1;
127 a b
128 100 a
129 101 b
130 SELECT LAST_INSERT_ID();
131 LAST_INSERT_ID()
132 100
133 DROP TABLE t1;