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

Most people do not understand the knowledge points of this article "mysql how to query the number of tables", so the editor summarizes the following content, detailed content, clear steps, and has a certain reference value. I hope you can get something after reading this article. Let's take a look at this "mysql how to query the number of tables" article.

In mysql, you can use the select statement with the count () function to query the number of tables in the database with the syntax of "SELECT count () FROM information_schema.TABLES WHERE TABLE_SCHEMA=' database name';".

The operating environment of this tutorial: windows10 system, mysql8.0.22 version, Dell G3 computer.

How to query the number of tables by mysql

View the number of database tables

The syntax is as follows:

SELECT count (TABLE_NAME) FROM information_schema.TABLES WHERE TABLE_SCHEMA='dbname'

Where dbname is the name of the database to view.

View the table structure:

Description tbname

You can also use abbreviations:

Desc tbname

Examples are as follows:

Select count (*) tables, table_schema from information_schema.tables where table_schema='work_ad' group by table_schema

The above is the content of this article on "how to query the number of tables in mysql". I believe we all have some understanding. I hope the content shared by the editor will be helpful to you. If you want to know more about the relevant knowledge, please pay attention to the industry information channel.

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.