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

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!

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.