mysql 统计多张表，列出每张表的数据总条数

一、概述

　　mysql统计多张表，分别列表每张表的总条数

二、示例:(使用子查询)

select count(*) as '学生总数' , 
(select count(*) from school_info) as '学校总数' ,
(select count(*) from teacher_info) as '老师总数',
(select count(*) from company_info) as '公司总数'
from student_info