mysql 内置

2019独角兽企业重金招聘Python工程师标准>>>

 查看所有表的记录数：

select table_name,table_rows from information_schema.tables where TABLE_SCHEMA = 'zkbc_gz' order by table_rows desc;

查看表的表结构以及注释：

 select COLUMN_NAME,IS_NULLABLE,COLUMN_TYPE,COLUMN_COMMENT from information_schema.columns where table_schema = 'zkbc_gz' #表所在数据库
 and table_name = 'bank_card' ; #你要查的表

 

转载于:https://my.oschina.net/iyinghui/blog/2963152