怎么查询表名

如何查询表名

mysql

在数据库db_name中有很多表，我想查询记录条数最少的那一张表的表名，有什么好办法啊？谢谢

use information_schema

select TABLE_NAME,TABLE_ROWS from TABLES where TABLE_SCHEMA= ‘db_name ‘ and TABLE_ROWS is not null order by TABLE_ROWS limit 1

use information_schema;

select table_name from tables where table_schema = ‘db_name ‘ and

table_rows in (select min(table_rows) from tables where table_schema= ‘db_name ‘)

;