1DROP TABLE IF EXISTS t1,t2,test1,test2;
2CREATE TABLE t1 (a int);
3INSERT INTO t1 VALUES (1),(2),(3);
4CREATE TABLE t2 (a int, b int);
5show tables;
6Tables_in_test
7t1
8t2
9select "--------------------" as "";
10
11--------------------
12Database: test
13+--------+
14| Tables |
15+--------+
16| t1     |
17| t2     |
18+--------+
19select "---- -v ------------" as "";
20
21---- -v ------------
22Database: test
23+--------+----------+
24| Tables | Columns  |
25+--------+----------+
26| t1     |        1 |
27| t2     |        2 |
28+--------+----------+
292 rows in set.
30
31select "---- -v -v ---------" as "";
32
33---- -v -v ---------
34Database: test
35+--------+----------+------------+
36| Tables | Columns  | Total Rows |
37+--------+----------+------------+
38| t1     |        1 |          3 |
39| t2     |        2 |          0 |
40+--------+----------+------------+
412 rows in set.
42
43select "----- -t -----------" as "";
44
45----- -t -----------
46Database: test
47+--------+------------+
48| Tables | table_type |
49+--------+------------+
50| t1     | BASE TABLE |
51| t2     | BASE TABLE |
52+--------+------------+
53select "---- -v -t ---------" as "";
54
55---- -v -t ---------
56Database: test
57+--------+------------+----------+
58| Tables | table_type | Columns  |
59+--------+------------+----------+
60| t1     | BASE TABLE |        1 |
61| t2     | BASE TABLE |        2 |
62+--------+------------+----------+
632 rows in set.
64
65select "---- -v -v -t ------" as "";
66
67---- -v -v -t ------
68Database: test
69+--------+------------+----------+------------+
70| Tables | table_type | Columns  | Total Rows |
71+--------+------------+----------+------------+
72| t1     | BASE TABLE |        1 |          3 |
73| t2     | BASE TABLE |        2 |          0 |
74+--------+------------+----------+------------+
752 rows in set.
76
77DROP TABLE t1, t2;
78End of 5.0 tests
79