Debian Codegraph @

mysql-test/suite/storage_engine/show_table_status.result

raw
1 DROP TABLE IF EXISTS t1, t2, t3;
2 CREATE TABLE t1 (a <INT_COLUMN>, b <CHAR_COLUMN>) ENGINE=<STORAGE_ENGINE> <CUSTOM_TABLE_OPTIONS>;
3 INSERT INTO t1 (a,b) VALUES (100,'a'),(2,'foo');
4 CREATE TABLE t2 (a <INT_COLUMN>, b <CHAR_COLUMN>) ENGINE=<STORAGE_ENGINE> <CUSTOM_TABLE_OPTIONS>;
5 INSERT INTO t2 (a,b) VALUES (1,'bar');
6 CREATE TABLE t3 (a <INT_COLUMN>, b <CHAR_COLUMN>) ENGINE=<STORAGE_ENGINE> <CUSTOM_TABLE_OPTIONS> CHARACTER SET utf8;
7 SHOW TABLE STATUS WHERE name IN ( 't1', 't2', 't3' );
8 Name t1
9 Engine <STORAGE_ENGINE>
10 Version 10
11 Row_format ###
12 Rows 2
13 Avg_row_length ###
14 Data_length ###
15 Max_data_length ###
16 Index_length ###
17 Data_free ###
18 Auto_increment NULL
19 Create_time ###
20 Update_time ###
21 Check_time NULL
22 Collation latin1_swedish_ci
23 Checksum NULL
24 Create_options
25 Comment
26 Max_index_length ###
27 Temporary N
28 Name t2
29 Engine <STORAGE_ENGINE>
30 Version 10
31 Row_format ###
32 Rows 1
33 Avg_row_length ###
34 Data_length ###
35 Max_data_length ###
36 Index_length ###
37 Data_free ###
38 Auto_increment NULL
39 Create_time ###
40 Update_time ###
41 Check_time NULL
42 Collation latin1_swedish_ci
43 Checksum NULL
44 Create_options
45 Comment
46 Max_index_length ###
47 Temporary N
48 Name t3
49 Engine <STORAGE_ENGINE>
50 Version 10
51 Row_format ###
52 Rows 0
53 Avg_row_length ###
54 Data_length ###
55 Max_data_length ###
56 Index_length ###
57 Data_free ###
58 Auto_increment NULL
59 Create_time ###
60 Update_time ###
61 Check_time NULL
62 Collation utf8_general_ci
63 Checksum NULL
64 Create_options
65 Comment
66 Max_index_length ###
67 Temporary N
68 DROP TABLE t1, t2, t3;