"Fossies" - the Fresh Open Source Software Archive

Member "drizzle-7.1.36-stable/docs/show.rst" (6 May 2012, 1430 Bytes) of package /linux/misc/old/drizzle-7.1.36-stable.tar.gz:


As a special service "Fossies" has tried to format the requested source page into HTML format (assuming markdown format). Alternatively you can here view or download the uninterpreted source code file. A member file download can also be achieved by clicking within a package contents listing on the according byte size field.

SHOW

All SHOW commands are shorthand forms of queries on the INFORMATION_SCHEMA and/or DATA_DICTIONARY. More data can be gained by executing queries directly on the tables found either the DATA_DICTIONARY or the INFORMATION_SCHEMA.

SHOW SCHEMAS

Will list the names of all the schemas in the current catalog.

SHOW TABLES

Will list the names of all the tables in the current schema.

SHOW TEMPORARY TABLES

SHOW TABLE STATUS

Will show the current status of tables for the current database which are currently in the table cache. A query (such as SELECT) may be needed to add a table to the table cache so that it can be shown in this output.

SHOW COLUMNS FROM table_name

SHOW INDEXES from table_name

SHOW WARNINGS

Shows the warnings and/or errors from the previous command.

SHOW ERRORS

Shows errors from the previous command.

SHOW CREATE SCHEMA schema_name

Shows the CREATE SCHEMA command required to recreate schema_name.

SHOW CREATE TABLE table_name

Shows the CREATE TABLE statement used to create the table table_name. Please note the AUTO_INCREMENT in this is the AUTO_INCREMENT specified at CREATE or ALTER TABLE time, not the current AUTO_INCREMENT value.

SHOW PROCESSLIST