把一个表中查询的结果存入另一个表中的方法

语法：insert into tablename1 (field) select field from tablename2 where condition;

示例：
insert into region_0(clientID,min_time,max_time,duration,count) select clientID,min(timestamp) as min_time,max (timestamp) as max_time,max(timestamp)-min(timestamp) as duration,count(clientID) from wc_day66 where region=0 and method=0 and status between 2 and 8 group by clientID;