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

This article will explain in detail the methods of mysql query table information for you. The editor thinks it is very practical, so I share it for you as a reference. I hope you can get something after reading this article.

Mysql queries table information by executing the [select * from tables where table_schema = "db_name";] command to view information about all tables in the database.

The specific methods are as follows:

Query the information of all the tables in one:

Use information_scheam;select * from tables where table_schema = "db_name"

Query information for a single table:

Use information_scheam;select * from tables where table_schema = "db_name" and table_name = "table_name1"

Query all the field information of a table:

Use db_name;show full columns from table_name1;show full columns from table_name2; on the mysql query table information sharing methods here, I hope that the above content can be of some help to you, can learn more knowledge. If you think the article is good, you can share it for more people to see.

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.