use information_schema;
SELECT
table_name, table_rows
FROM
tables
WHERE
TABLE_SCHEMA = ‘xxx’
ORDER BY table_rows ASC;