← Back to branch summary

~stewart/drizzle/embedded-innodb-create-select-transaction-arrgh

« back to all changes in this revision

Viewing changes to mysql-test/r/mysqlshow.result

  • Committer: brian
  • Date: 2008-06-25 05:29:13 UTC
  • Revision ID: brian@localhost.localdomain-20080625052913-6upwo0jsrl4lnapl
clean slate

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/r/mysqlshow.result
 
1
DROP TABLE IF EXISTS t1,t2,test1,test2;
 
2
CREATE TABLE t1 (a int);
 
3
INSERT INTO t1 VALUES (1),(2),(3);
 
4
CREATE TABLE t2 (a int, b int);
 
5
show tables;
 
6
Tables_in_test
 
7
t1
 
8
t2
 
9
select "--------------------" as "";
 
10
 
 
11
--------------------
 
12
Database: test
 
13
+--------+
 
14
| Tables |
 
15
+--------+
 
16
| t1     |
 
17
| t2     |
 
18
+--------+
 
19
select "---- -v ------------" as "";
 
20
 
 
21
---- -v ------------
 
22
Database: test
 
23
+--------+----------+
 
24
| Tables | Columns  |
 
25
+--------+----------+
 
26
| t1     |        1 |
 
27
| t2     |        2 |
 
28
+--------+----------+
 
29
2 rows in set.
 
30
 
 
31
select "---- -v -v ---------" as "";
 
32
 
 
33
---- -v -v ---------
 
34
Database: test
 
35
+--------+----------+------------+
 
36
| Tables | Columns  | Total Rows |
 
37
+--------+----------+------------+
 
38
| t1     |        1 |          3 |
 
39
| t2     |        2 |          0 |
 
40
+--------+----------+------------+
 
41
2 rows in set.
 
42
 
 
43
select "----- -t -----------" as "";
 
44
 
 
45
----- -t -----------
 
46
Database: test
 
47
+--------+------------+
 
48
| Tables | table_type |
 
49
+--------+------------+
 
50
| t1     | BASE TABLE |
 
51
| t2     | BASE TABLE |
 
52
+--------+------------+
 
53
select "---- -v -t ---------" as "";
 
54
 
 
55
---- -v -t ---------
 
56
Database: test
 
57
+--------+------------+----------+
 
58
| Tables | table_type | Columns  |
 
59
+--------+------------+----------+
 
60
| t1     | BASE TABLE |        1 |
 
61
| t2     | BASE TABLE |        2 |
 
62
+--------+------------+----------+
 
63
2 rows in set.
 
64
 
 
65
select "---- -v -v -t ------" as "";
 
66
 
 
67
---- -v -v -t ------
 
68
Database: test
 
69
+--------+------------+----------+------------+
 
70
| Tables | table_type | Columns  | Total Rows |
 
71
+--------+------------+----------+------------+
 
72
| t1     | BASE TABLE |        1 |          3 |
 
73
| t2     | BASE TABLE |        2 |          0 |
 
74
+--------+------------+----------+------------+
 
75
2 rows in set.
 
76
 
 
77
DROP TABLE t1, t2;
 
78
Database: information_schema  Wildcard: TABLE%
 
79
+-------------------+
 
80
|      Tables       |
 
81
+-------------------+
 
82
| TABLES            |
 
83
| TABLE_CONSTRAINTS |
 
84
| TABLE_PRIVILEGES  |
 
85
+-------------------+
 
86
Database: INFORMATION_SCHEMA  Wildcard: TABLE%
 
87
+-------------------+
 
88
|      Tables       |
 
89
+-------------------+
 
90
| TABLES            |
 
91
| TABLE_CONSTRAINTS |
 
92
| TABLE_PRIVILEGES  |
 
93
+-------------------+
 
94
Wildcard: inf_rmation_schema
 
95
+--------------------+
 
96
|     Databases      |
 
97
+--------------------+
 
98
| information_schema |
 
99
+--------------------+
 
100
End of 5.0 tests