~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to docs/show.rst

[patch 003/129] Merge patch for revision 1788 from InnoDB SVN:
revno: 1788
revision-id: svn-v4:16c675df-0fcb-4bc9-8058-dcc011a37293:branches/zip:5670
parent: svn-v4:16c675df-0fcb-4bc9-8058-dcc011a37293:branches/zip:5663
committer: marko
timestamp: Wed 2009-08-12 12:16:37 +0000
message:
  branches/zip: trx_undo_rec_copy(): Add const qualifier to undo_rec.
  This is a non-functional change.
modified:
  include/trx0rec.h              2@16c675df-0fcb-4bc9-8058-dcc011a37293:trunk%2Finclude%2Ftrx0rec.h
  include/trx0rec.ic             2@16c675df-0fcb-4bc9-8058-dcc011a37293:trunk%2Finclude%2Ftrx0rec.ic
  trx/trx0rec.c                  2@16c675df-0fcb-4bc9-8058-dcc011a37293:trunk%2Ftrx%2Ftrx0rec.c
diff:
=== modified file 'include/trx0rec.h'

Show diffs side-by-side

added added

removed removed

Lines of Context:
1
 
SHOW
2
 
=====
3
 
 
4
 
All show commans are mapped to table functions in Drizzle. More data can be
5
 
gained by exeucting queries directly on the tables found either the
6
 
DATA_DICTIONARY or the INFORMATION_SCHEMA.
7
 
 
8
 
SHOW SCHEMAS
9
 
------------
10
 
 
11
 
Will list the names of all the schemas in the current catalog.
12
 
 
13
 
SHOW TABLES
14
 
-----------
15
 
 
16
 
Will list the names of all the tables in the current schema.
17
 
 
18
 
SHOW TEMPORARY TABLES
19
 
---------------------
20
 
 
21
 
SHOW TABLE STATUS
22
 
-----------------
23
 
 
24
 
 
25
 
SHOW COLUMNS FROM table_name
26
 
----------------------------
27
 
 
28
 
SHOW INDEXES from table_name
29
 
----------------------------
30
 
 
31
 
 
32
 
SHOW WARNINGS
33
 
-------------
34
 
 
35
 
Shows the warnings and/or errors from the previous command.
36
 
 
37
 
SHOW ERRORS
38
 
-----------
39
 
 
40
 
Shows errors from the previous command.
41
 
 
42
 
SHOW CREATE SCHEMA schema_name
43
 
------------------------------
44
 
 
45
 
Shows the CREATE SCHEMA command required to recreate schema_name.
46
 
 
47
 
SHOW CREATE TABLE table_name
48
 
----------------------------
49
 
 
50
 
Shows the CREATE TABLE statement used to create the table table_name.
51
 
 
52
 
SHOW PROCESSLIST
53
 
----------------
54