Get records count for all tables in MySQL database

MySQL

 

The world's second most used open-source database. Skyvia requires the server to be available from Internet. Skyvia supports MySQL, Percona, and MariaDB servers.

A way to get the count of rows in all tables in a mysql database without running a "SELECT count()" on each table

Query Text

SELECT
    SUM(TABLE_ROWS) 
FROM 
    INFORMATION_SCHEMA.TABLES 
WHERE
    TABLE_SCHEMA = '{your_db}'
  

Open Query