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

This article mainly explains the "MySQL commonly used show commands", the article explains the content is simple and clear, easy to learn and understand, the following please follow the editor's ideas slowly in depth, together to study and learn "MySQL commonly used show commands" bar!

There are many basic commands in MySQL, and the show command is also one of them. It is easy to confuse the use of the show command in many users. This paper collects many uses of the show command.

one

two

three

four

five

six

seven

eight

nine

ten

eleven

twelve

thirteen

fourteen

fifteen

sixteen

seventeen

eighteen

A. show tables or show tables from database_name;-- displays the names of all tables in the current database.

B. show databases;-- displays the names of all databases in mysql.

C. show columns from table_name from database_name; or show columns from database_name.table_name;-- displays the column names in the table.

D. show grants for user_name;-displays the permissions of a user, and the result is similar to the grant command.

E. show index from table_name;-displays the index of the table.

F. show status;-- displays information about some system-specific resources, such as the number of threads running.

G. show variables;-displays the name and value of the system variable.

H. Show processlist;-shows all processes running on the system, that is, queries that are currently being executed. Most users can view their own processes, but if they have process privileges, they can view everyone's processes, including passwords.

I. show table status;-- displays information about each table in the currently used or specified database. The information includes the table type and the latest update time of the table.

J. Show privileges;-displays the different permissions supported by the server.

K. show create database database_name;-shows whether the create database statement can create the specified database.

L. Show create table table_name;-shows whether the create database statement can create the specified database.

M. show engies;-shows the storage engine and default engine available after installation.

N. show innodb status;-- displays the status of the innoDB storage engine.

O. Show logs;-displays the logs of the BDB storage engine.

P. show warnings;-- displays errors, warnings, and notifications from the last executed statement.

Q. Show errors;-- displays only the error caused by the last execution statement.

R. Show [storage] engines;-shows the available storage engine and default engine after installation.

Thank you for your reading, the above is the content of "show commands commonly used in MySQL". After the study of this article, I believe you have a deeper understanding of the problem of show commands commonly used in MySQL, and the specific use needs to be verified in practice. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!

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.