查询MySQL库下所有表名,数据为空的表名

select table_name, table_rows from information_schema.tables where table_schema = 'ahbo' and table_rows <1;

posted @ 2017-08-24 17:21  duyunchao  阅读(995)  评论(0编辑  收藏  举报