关于mysql:mysql-获取表名及表字段数

依据如下语句，查问对应数据；

select count(a.table_name),b.table_name from information_schema.COLUMNS  a, ( select table_namefrom information_schema.`TABLES`where  table_schema='hdtb_pilot') bwhere a.table_name = b.table_namegroup by a.table_name