How can we query the amount of data in each table in My…

1 year ago
Benjamin Taylor
1 minute

You can use the following SQL statement to query the amount of data in each table:

SELECT TABLE_NAME, TABLE_ROWS
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA = 'your_database_name';

Replace your_database_name with the name of your actual database. This SQL statement will retrieve the name and row count information of each table from the INFORMATION_SCHEMA.TABLES system view.

bannerAds