多谢 chinaworker(网络混混 Ken.Hrcn.CN) 但是union返回了两行count的值
select count(id) as num from a1
union
select count(id) as num from a2结果是
num
---
2
9
---
select count(id) as num from a1
union
select count(id) as num from a2结果是
num
---
2
9
---
先把这个做成一个视图,如保存为view1然后再进行下面的:select count (*) as cnt from view1
得到总条数其余的应该差不多了。
FROM aa
LEFT JOIN bb ON 1
LIMIT 1
FROM aa
LEFT JOIN bb ON 1
LIMIT 1
FROM aa
LEFT JOIN bb ON 1
LEFT JOIN cc ON 1
LIMIT 1
LEFT JOIN cc ON 1
where ........
LIMIT 1
SELECT count(DISTINCT aa.id)+count(DISTINCT bb.id) +count(DISTINCT cc.id)
FROM aa
LEFT JOIN bb ON 1
LEFT JOIN cc ON 1
//----------------------------------
where
binary aa.name like '%李%'
||
binary bb.name like '%李%'
||
binary cc.name like '%李%'
//----------------------------------
LIMIT 1希望等到带有条件的联合统计结果,上面的SQL不行
已经一天了,现在头晕脑胀的
还要请大家帮忙了