create temporary table tmp select * from 你的表 where ....
解决了感觉比较麻烦,原来4.1下的语句是: SELECT count( * ) AS cc FROM (SELECT DISTINCT (ip)FROM ANALYSE ) AS ff到3.2修改为: create temporary table tmp SELECT DISTINCT (ip) FROM analyse AS ff; select count(*) as cc from tmp;
SELECT count( * ) AS cc FROM (SELECT DISTINCT (ip)FROM ANALYSE ) AS ff到3.2修改为:
create temporary table tmp SELECT DISTINCT (ip) FROM analyse AS ff;
select count(*) as cc from tmp;