← Back to branch summary

~ubuntu-branches/ubuntu/precise/mysql-5.1/precise

« back to all changes in this revision

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

  • Committer: Bazaar Package Importer
  • Author(s): Norbert Tretkowski
  • Date: 2010-03-17 14:56:02 UTC
  • Revision ID: james.westby@ubuntu.com-20100317145602-x7e30l1b2sb5s6w6
Tags: upstream-5.1.45
Import upstream version 5.1.45

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
 
79
+---------------------------------------+
 
80
|                Tables                 |
 
81
+---------------------------------------+
 
82
| CHARACTER_SETS                        |
 
83
| COLLATIONS                            |
 
84
| COLLATION_CHARACTER_SET_APPLICABILITY |
 
85
| COLUMNS                               |
 
86
| COLUMN_PRIVILEGES                     |
 
87
| ENGINES                               |
 
88
| EVENTS                                |
 
89
| FILES                                 |
 
90
| GLOBAL_STATUS                         |
 
91
| GLOBAL_VARIABLES                      |
 
92
| KEY_COLUMN_USAGE                      |
 
93
| PARTITIONS                            |
 
94
| PLUGINS                               |
 
95
| PROCESSLIST                           |
 
96
| PROFILING                             |
 
97
| REFERENTIAL_CONSTRAINTS               |
 
98
| ROUTINES                              |
 
99
| SCHEMATA                              |
 
100
| SCHEMA_PRIVILEGES                     |
 
101
| SESSION_STATUS                        |
 
102
| SESSION_VARIABLES                     |
 
103
| STATISTICS                            |
 
104
| TABLES                                |
 
105
| TABLE_CONSTRAINTS                     |
 
106
| TABLE_PRIVILEGES                      |
 
107
| TRIGGERS                              |
 
108
| USER_PRIVILEGES                       |
 
109
| VIEWS                                 |
 
110
+---------------------------------------+
 
111
Database: INFORMATION_SCHEMA
 
112
+---------------------------------------+
 
113
|                Tables                 |
 
114
+---------------------------------------+
 
115
| CHARACTER_SETS                        |
 
116
| COLLATIONS                            |
 
117
| COLLATION_CHARACTER_SET_APPLICABILITY |
 
118
| COLUMNS                               |
 
119
| COLUMN_PRIVILEGES                     |
 
120
| ENGINES                               |
 
121
| EVENTS                                |
 
122
| FILES                                 |
 
123
| GLOBAL_STATUS                         |
 
124
| GLOBAL_VARIABLES                      |
 
125
| KEY_COLUMN_USAGE                      |
 
126
| PARTITIONS                            |
 
127
| PLUGINS                               |
 
128
| PROCESSLIST                           |
 
129
| PROFILING                             |
 
130
| REFERENTIAL_CONSTRAINTS               |
 
131
| ROUTINES                              |
 
132
| SCHEMATA                              |
 
133
| SCHEMA_PRIVILEGES                     |
 
134
| SESSION_STATUS                        |
 
135
| SESSION_VARIABLES                     |
 
136
| STATISTICS                            |
 
137
| TABLES                                |
 
138
| TABLE_CONSTRAINTS                     |
 
139
| TABLE_PRIVILEGES                      |
 
140
| TRIGGERS                              |
 
141
| USER_PRIVILEGES                       |
 
142
| VIEWS                                 |
 
143
+---------------------------------------+
 
144
Wildcard: inf_rmation_schema
 
145
+--------------------+
 
146
|     Databases      |
 
147
+--------------------+
 
148
| information_schema |
 
149
+--------------------+
 
150
End of 5.0 tests