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