MySQL Show statement usage

MySQL Show statements are commonly used. The following describes the usage of MySQL Show statements. If you are interested in MySQL Show statements, take a look.

 
 

  
  
show databases;  
  
  
 
  
  
show tables from db_name;  
  
  
 
  
  
show columns from table_name from db_name;  
  
  
 
  
  
show index from talbe_name [from db_name];  
  
  
 
  
  
show status;  
  
  
 
  
  
show variables;  
  
  
 
  
  
show [full] processlist;  
  
  
 
  
  
show table status [from db_name];  
  
  
 
  
  
show grants for user;  
 
 

In addition to status, processlist, and grants, other options can contain the like wild option, which can use the SQL '%' and '_' characters;

Show databases like '% T ';

All databases whose names end with the 'T' character are listed.

The preceding section describes the usage of the MySQL Show statement.

How to create an association table in MySQL

MySQL connection query Overview

Optimization instance for MySQL random Query

MySQL sorting usage

How to enable MySQL slow Query