Commands for how to view MySQL database tables
This article mainly introduces "how to view the command of MySQL database table". In the daily operation, I believe many people have doubts about how to view the command of MySQL database table. The editor consulted all kinds of information and sorted out a simple and easy-to-use operation method. I hope it will be helpful to answer the doubt of "how to view the command of MySQL database table". Next, please follow the editor to study!
If you need to see what MySQL database tables are in the MySQL database, how do you do that? The following editor will explain how to view MySQL database tables under the command?
Commands for how to view MySQL database tables
Enter under MySQLCommandlineclient
View the database currently in use:
Mysql > selectdatabase ()
Mysql > status
Mysql > showtables
Mysql > showdatabases;// can check which databases are available, and return the database name (databaseName)
Mysql > usedatabaseName;// change the database currently in use
Mysql > showtables;// returns the names of all tables under the current database
Commands for how to view MySQL database tables
Mysql > showtablesfromdatabaseName;//databaseName can be obtained using showdatabases
The command for mysql to view the table structure is as follows:
Desc table name
Showcolumnsfrom table name
Or
Describe table name
Showcreatetable table name
Or
Useinformation_schema
Select*fromcolumnswheretable_name=' table name'
View warnings:
Rowsmatched:1Changed:0Warnings:1mysql > showwarnings +-- + | Level | Code | Message | +- -- + | Warning | 1265 | Datatruncatedforcolumn'name'atrow3 | +-+ 1rowinset
At this point, the study of "commands on how to view MySQL database tables" is over. I hope to be able to solve your doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!
