找出数据t库中行数多于10000的表,并按行数从高到底排列:
select table_rows, table_name from tables where table_rows >= 100000 order by table_rows desc;
找出数据t库中行数多于10000的表,并按行数从高到底排列:
select table_rows, table_name from tables where table_rows >= 100000 order by table_rows desc;