use information_schema; select table_name,table_rows from tableswhere TABLE_SCHEMA = 'testdb' ORDER BY table_name desc;