mysql带条件子查询的执行顺序是怎样的
SELECT
(
SELECT
count(id)
FROM
project_distribute
WHERE
net_status = '内网'
) AS intranet,
(
SELECT
count(id)
FROM
project_distribute
WHERE
net_status = '外网'
) AS network,
(
SELECT
count(id)
FROM
project_distribute
WHERE
net_status IS NULL
) AS other;
这个SQL,在程序中用jdbc获取值时,只能获取到other的值,其他值均为0,我初步测试,应该是三个子查询的条件影响的,把条件全部去掉,那么三个只都能获取到,不然只能获取条件是 IS NULL的值,想请教一下是为什么?,如何解决