SELECT id FROM
(SELECT from_id as id FROM email
union ALL
SELECT to_id as id FROM email) as tb_email GROUP by id HAVING COUNT(id)>100;
(SELECT from_id as id FROM email
union ALL
SELECT to_id as id FROM email) as tb_email GROUP by id HAVING COUNT(id)>100;
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT from_id as id FROM `email` union ALL SELECT to_id as id
Your MySQL connection id is 2 to server version: 4.0.17-nt
我在PHP中用phpinfo()看了一下,数据库可能是3.23.49 版本的如果我的数据库不支持子查询,该怎么完成我需要的查询?
SELECT count(*), from_id FROM email GROUP BY from_id;
SELECT count(*), to_id FROM email GROUP BY to_id;
FROM email
WHERE SELECT count(*), from_id FROM email GROUP BY from_id AND
SELECT count(*), to_id FROM email GROUP BY to_id;