点击(此处)折叠或打开
-
use information_schema;
-
-
select table_name,table_rows from tables
-
where TABLE_SCHEMA = 'testdb'
- order by table_rows desc;
39162阅读 2评论2013-11-19 jonelaw
分类：Mysql/postgreSQL
点击(此处)折叠或打开
结果不准确
use information_schema;SET group_concat_max_len = 100000;<br />SELECT concat(\'select tn,ct from (\',substring(a.ss,1, locate(\', count(*)\',a.ss)-1),\' as tn, count(*) as ct\',substring(a.ss, locate(\', count(*)\',a.ss)+10,LENGTH(a.ss)-locate(\', count(*)\',a.ss)-19) ,\') t ORDER BY t.ct desc;\' ) INTO @str from <br />(select GROUP_CONCAT(t.qs SEPARATOR \' \\n\') ss from(select concat(\'select&nb