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