Shulou(Shulou.com)06/01 Report--

This article mainly introduces the commonly used mysql system commands, the contents of the articles are carefully selected and edited by the author, with a certain pertinence, the reference significance for everyone is still relatively great, the following with the author to understand the commonly used mysql system commands.

Desc table name; / / table information

Show columns from table name; / / table field

Describe table name; / / table information

Show create table table name; / / table creation statement

Show create database database name; / / display database information

Show table status from database name; / / database status

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 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.

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

Show columns from table_name from database_name; / / displays the column names in the table

Show columns from database_name.table_name; / / displays the column names in the table

Show grants for user_name@localhost; / / displays the permissions of a user, and the result is similar to the grant command

Show index from table_name; / / display the index of the table show status; explanation: displays information about some system-specific resources, such as the number of threads running

Show variables; / / displays the name and value of the system variable show privileges; explanation: displays the different permissions supported by the CVM

Show create database database_name; / / shows whether the create database statement can create the specified database

Show create table table_name; / / shows whether the create database statement can create the specified database

Show engies; / / shows the storage engine and default engine available after installation.

Show innodb status; / / displays the status of the innoDB storage engine

Show logs; / / displays the logs of the BDB storage engine

Show warnings; / / displays errors, warnings, and notifications from the last executed statement

Show errors; / / displays only the error caused by the last execution statement

Show engine innodb status;// found deadlock information.

Select SUBSTRING_INDEX (host,':',1) as ip, count (*) from information_schema.processlist group by ip / / number of ip of current database connections

Show status query running status, with 300 + pieces of data

After reading the above commonly used mysql system commands, many readers must have some understanding, if you need to get more industry knowledge and information, you can continue to follow our industry information column.

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.