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

Today, I would like to share with you the relevant knowledge points about how mysql queries all the tables in the database. The content is detailed and the logic is clear. I believe most people still know too much about this knowledge, so share this article for your reference. I hope you can get something after reading this article. Let's take a look.

In mysql, all tables in the database can be queried by "select table name from information_schema.tables where table_schema= database", and "information_schema.tables" can access database metadata.

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

How does mysql query all the tables in the library

Using the select command, you can query all table names

It is written as follows:

Select table name from information_schema.tables where table_schema=' current database'

[INFORMATION_SCHEMA Database] is included with MySQL and provides a way to access database metadata. What is metadata? Metadata is data about data, such as database or table names, data types of columns, or access permissions.

Sometimes other terms used to describe this information include "data dictionary" and "system catalog".

In MySQL, think of [INFORMATION_SCHEMA] as a database, or rather an information database. It holds information about all other databases maintained by the MySQL server. Such as the name of the database, the table of the database, the data type and access of the table column, etc.

There are several read-only tables in [INFORMATION_SCHEMA]. They are actually views, not basic tables, so you won't be able to see any files associated with them.

These are all the contents of the article "how to query all tables in mysql Library". Thank you for reading! I believe you will gain a lot after reading this article. The editor will update different knowledge for you every day. If you want to learn more 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.