Show tables or show tables from database_name; Displays the names of all tables in the current database
show databases; Displays the names of all databases in MySQL
Show columns from table_name to database_name; or show columns from Database_name.table_name; Display column names in a table
Show grants for User_name@localhost; Displays the permissions of a user, displaying the results similar to the grant command
Show index from TABLE_NAME; Show Index of Table
Show status; Displays information about some system-specific resources, such as the number of threads running
Show variables; Display the name and value of a system variable
Show Processlist; Displays all processes running on the system, which are currently executing queries. Most users can view
Their own processes, but if they have process permissions, they can view all of the processes, including passwords.
Show table status; Displays information for each table in the currently used or specified database. Information includes the latest update times for table types and tables
Show privileges; Displays the different permissions supported by the server
Show CREATE DATABASE database_name; Shows whether the CREATE DATABASE statement is capable of creating the specified databases
Show CREATE TABLE table_name; Shows whether the CREATE DATABASE statement is capable of creating the specified databases
Show Engies; Displays the storage engine and default engine available after installation.
Show InnoDB status; Displays the status of the InnoDB storage engine
Show logs; Display log of BDB storage engine
Show warnings; Displays errors, warnings, and notifications from the last executed statement
Show errors; Show only the errors generated by the last execution statement
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.
