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