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

This article mainly tells you how to use Navicat to achieve row counting from multiple tables and views in MySQL. You can look up relevant professional terms on the Internet or find some related books to supplement them. We will not dabble here. Let's go straight to the topic. We hope that using Navicat to achieve row counting from multiple tables and views in MySQL can bring you some practical help.

Download the latest version of Navicat Premium

Navicat Premium is a management tool that can connect to multiple databases. It allows you to connect to MySQL, Oracle and PostgreSQL databases simultaneously with a single program, making it more convenient to manage different types of databases.

In the previous article getting the advanced number of rows in MySQL (part 2), we used the native COUNT () function to calculate unique values and values that meet the criteria. In the final third part of today, we will learn how to get row counts from all tables in the database or the entire schema.

Query information schema database

You do not have to run a count query on each table to get the number of rows. If you plan to run external scripts multiple times, this will be tedious and may require external scripts.

The INFORMATION_SCHEMA database is the place where each MySQL instance stores information about all other databases maintained by the MySQL cloud server. Sometimes referred to as data dictionaries and system directories, it is an ideal place to find information about the data types or access permissions of databases, tables, and columns.

The INFORMATION_SCHEMA "TABLES" table provides information about other tables in the database. By querying it, you can get the exact number of rows through a query.

Table count of a database

It is easy to get the number of rows in a database. You only need to add a WHERE clause that is conditional that the table_schema column matches the database name:

Use Navicat to achieve row counting from multiple tables and views in MySQL. Let's talk about this first. If you want to know about other related issues, you can continue to follow our industry information. Our section will capture some industry news and professional knowledge to share with you every day.

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.