How can I view the amount of data in all tables in MySQL?

2 years ago
Noah Thompson
1 minute

In MySQL, you can use the following statement to view the amount of data in all tables.

SELECT table_name, table_rows
FROM information_schema.tables
WHERE table_schema = 'your_database_name';

Replace “your_database_name” with the name of the database you want to query. This will retrieve a result set that includes the table names and the number of rows in each table.

bannerAds