use testdb;

INSERT INTO TABLE biz_data_count
select method,biz_data,count(1) as count,max(timestamp) as timestamp
from qa_log
where method='com.ai.handler.plan.detail.index.info'
group by method,biz_data;

INSERT INTO TABLE biz_data_response
select method,biz_data,uid,timestamp,response
from qa_log
where method='com.ai.handler.plan.detail.index.info';