SELECT a.`TABLE_SCHEMA` AS DB_NAME , a.`TABLE_NAME` , a.`TABLE_ROWS` ,a.`ENGINE` -- , a.* FROM information_schema.`TABLES` a LEFT JOIN information_schema.`TABLE_CONSTRAINTS` b ON a.`TABLE_NAME` = b.`TABLE_NAME` AND a.`TABLE_SCHEMA` = b.`TABLE_SCHEMA` WHERE b.`TABLE_SCHEMA` IS NULL AND a.`TABLE_TYPE` = 'BASE TABLE' AND a.`TABLE_SCHEMA` NOT IN ('information_schema','test','mysql','performance_schema') ORDER BY DB_NAME ,a.`TABLE_ROWS` DESC ;
您可能感興趣的文章:
深入探尋mysql自增列導致主鍵重復問題的原因mysql把主鍵定義為自動增長標識符類型MySQL生產庫Insert了2次同樣的記錄但是主鍵ID是不一樣的問題的分析過程深入Mysql,SqlServer,Oracle主鍵自動增長的設置詳解MySQL查詢優化:用子查詢代替非主鍵連接查詢實例介紹Oracle與Mysql主鍵、索引及分頁的區別小結MySQL 主鍵與索引的聯系與區別分析sqlserver數據庫主鍵的生成方式小結(sqlserver,mysql)mysql下創建字段并設置主鍵的php代碼MySQL 創建主鍵,外鍵和復合主鍵的語句MySQL里Create Index 能否創建主鍵 Primary KeyMysql主鍵相關的sql語句集錦
