Shulou(Shulou.com)05/31 Report--

In this issue, Xiaobian will bring you about how to operate show in mysql. The article is rich in content and analyzes and narrates from a professional perspective. After reading this article, I hope you can gain something.

SHOW CHARACTER SET

Show all available character sets

SHOW CHARACTER SET;SHOW CHARACTER SET LIKE 'latin%';

SHOW COLLATION

The output includes all available character sets

SHOW COLLATION;SHOW COLLATION LIKE 'latin1%';

SHOW COLUMNS

Displays information about columns in a given table. This statement also works for views.

SHOW COLUMNS FROM mydb.mytable;SHOW COLUMNS FROM mytable FROM mydb;

SHOW CREATE DATABASE

Displays the CREATE DATABASE statement used to create a given database. You can also use SHOW CREATE SCHEMA.

SHOW CREATE DATABASE test;SHOW CREATE DATABASE test\G;

SHOW CREATE TABLE

Show sql statements that create tables

SHOW CREATE TABLE java;SHOW CREATE TABLE java\G;

SHOW DATABASES

SHOW ASES can enumerate databases on MySQL server hosts. You can also get this listing using the mysqlshow command. You can only see databases for which you have certain permissions, unless you have global SHOW ASES 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 seeing what the default engine is.

SHOW ENGINES;SHOW ENGINES\G;

SHOW ERRORS

This statement displays only errors, not errors, warnings, and cautions.

SHOW COUNT(*) ERRORS;SHOW ERRORS;

SHOW GRANTS

View related permissions

SHOW GRANTS FOR user;SHOW GRANTS FOR CURRENT_USER;SHOW GRANTS FOR CURRENT_USER();

SHOW INDEX

SHOW INDEX returns table index information.

SHOW INDEX FROM mydb.mytable;SHOW INDEX FROM mytable FROM mydb;

SHOW INNODB STATUS(mysql5.6 will report error)

View server information and locate problems

This is synonymous with SHOW ENGINE INNODB STATUS, but is deprecated.

SHOW OPEN TABLES

Lists the non-TEMPORARY tables currently open in the table cache.

SHOW OPEN TABLES;

SHOW PRIVILEGES

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

SHOW PRIVILEGES;

SHOW PROCESSLIST

Show which threads are running, often show full processlist to see the number of connections to mysql. You can also get this information using the mysqladmin processlist statement. If you have SUPER permission, you can see all threads. Otherwise, you can only see your own threads

SHOW STATUS

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

SHOW STATUS;

SHOW TABLE STATUS

SHOW STATUS is similar in nature to SHOW TABLE, but can provide a lot of information about each table. You can also get this listing using the mysqlshow --status db_name command.

This statement also displays view information.

SHOW TABLE STATUS;SHOW TABLE STATUS FROM test;

SHOW TABLES

SHOW TABLES enumerates the non-TEMPORARY tables in a given database. You can also get this listing using the mysqlshow db_name command.

SHOW TABLES;

SHOW TRIGGERS

SHOW TRIGGERS lists the triggers currently defined by MySQL Server.

SHOW TRIGGERS;

SHOW VARIABLES

View variables about configuration

SHOW GLOBAL VARIABLES;SHOW SESSION VARIABLES;SHOW VARIABLES LIKE 'have%';

SHOW WARNINGS

Displays error, warning, and caution messages caused by the statement that generated the last message. If the last statement that used the table did not generate a message, nothing is displayed. SHOW ERRORS is its related statement, displaying only errors.

SHOW COUNT(*) WARNINGS;SHOW WARNINGS; The above is how to operate the show in mysql shared by everyone. If there is a similar doubt, please refer to the above analysis for understanding. If you want to know more about it, please pay attention to the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.