Show operation for MySQL

SHOW CHARACTER SET

Show all the available character sets

CHARACTER SET  CHARACTERSETlike'latin%';

SHOW COLLATION

The output includes all available character sets

 like ' latin1% ';

SHOW COLUMNS

Displays the information for each column in a given table, and this statement also works for the view.

from from from MyDB; 

SHOW CREATE DATABASE

Displays the CREATE DATABASE statement for creating the given databases. You can also use the show CREATE SCHEMA.

CREATE DATABASE  CREATEDATABASE test\g;

SHOW CREATE TABLE

CREATE TABLE  CREATETABLE java\g;

SHOW DATABASES

SHOW databases can enumerate databases on the MySQL server host. You can also use the mysqlshow command to get this list. You can only see databases for which you have certain permissions, unless you have global show databases permissions.

SHOW DATABASES;

SHOW ENGINE

Show engine displays log or status information for the storage engine. The following statements are currently supported:

SHOW ENGINE BDB LOGS; SHOW ENGINE INNODB STATUS;

SHOW ENGINES

Show engines displays status information for the storage engine. This statement is useful for checking whether a storage engine is supported, or for viewing what the default engine is.

SHOW ENGINES; SHOW Engines\g;

SHOW ERRORS

The statement displays only errors and does not display errors, warnings, and attention.

COUNT (*) ERRORS; SHOW ERRORS;

SHOW GRANTS

 for User  forcurrent_userfor Current_User ();

SHOW INDEX

SHOW index Returns the table indexing information.

INDEX  from  INDEX from MyDB;

SHOW INNODB STATUS

This is a synonym for show ENGINE INNODB status, but is not in favor of use.

SHOW LOGS

This is a synonym for show ENGINE BDB logs, but is not in favor of use.

SHOW OPEN TABLES

Lists the non-temporary tables that are currently open in the table cache.

OPEN TABLES;

SHOW Privileges

Displays the list of system permissions supported by the MySQL server. The exact output depends on the version of your server

privileges;

SHOW processlist

Shows which threads are running. You can also use the mysqladmin processlist statement to get this information. If you have super privileges, you can see all the threads. Otherwise, you can only see your own threads

SHOW STATUS

Provides server state information. This information can also be obtained using the mysqladmin extended-status command.

SHOW STATUS;

SHOW TABLE STATUS

The Show table status is similar in nature to show table, but it can provide a lot of information for each table. You can also use the mysqlshow--status db_name command to get this list.

This statement also displays the view information.

Tabletable from test;

SHOW TABLES

SHOW tables lists the non-temporary tables in a given database. You can also use the mysqlshow db_name command to get this list.

SHOW TABLES;

SHOW TRIGGERS

SHOW triggers lists the triggers that are currently defined by the MySQL server.

SHOW TRIGGERS;

SHOW VARIABLES

 like ' have% ';

SHOW WARNINGS

Displays the errors, warnings, and note messages that are caused by the previous statement that generated the message. If the previous statement using the table does not generate a message, nothing is displayed. Show errors is its related statement and displays only errors.

COUNT (*) WARNINGS; SHOW WARNINGS;

Transfer from Http://dev.mysql.com/doc/refman/5.1/zh/sql-syntax.html#show

Show operation for MySQL