MySQL两张表比较count大小

例如现在同一数据库下的两张表A和B，想要比较两张表数据的条数不难

如果两张表的内容每天都是变动的，那么用一条sql如何进行比较呢？

参考如下：

select (select count(*) as num1 from A) as num1,(select count(*) as num2 from B ) as num2, 
case 
when (select count(*) as num1 from A) =(select count(*) as num2 from B ) then '='
when (select count(*) as num1 from A) <(select count(*) as num2 from B ) then '<'
else  '>' end as 'compare';

结果将得到一行三列的数据集

分别是num1、num2、compare

前两个为具体数值

第三个为得到的比较运算符

如：