247
mysql 臨時表 創建和插入
mysql 2張表插入到臨時表裏
一個項目用到多張表數據合計查詢
by 夜色紫宸風
DROP TABLE IF EXISTS tmp_table; CREATE TEMPORARY TABLE tmp_table SELECT appid,uid FROM `sz_app_credit_log_201111`; INSERT INTO tmp_table SELECT appid,uid FROM `sz_app_credit_log`; SELECT * FROM tmp_table;
具體例子
DROP TABLE IF EXISTS tmp_table;
CREATE TEMPORARY TABLE tmp_table SELECT appid,uid,sum(ovalue) as s FROM `sz_app_credit_log_201111` l where l.appid='7' and l.operate='add' and l.dateline>=UNIX_TIMESTAMP('2011-11-01') and l.dateline<UNIX_TIMESTAMP('2011-12-01') GROUP BY uid;
INSERT INTO tmp_table SELECT appid,uid,sum(ovalue) as s FROM `sz_app_credit_log` l where l.appid='7' and l.operate='add' and l.dateline>=UNIX_TIMESTAMP('2011-11-01') and l.dateline<UNIX_TIMESTAMP('2011-12-01') GROUP BY uid;
SELECT t.appid,t.uid,m.tel,sum(t.s) as s FROM tmp_table t left join sz_ucenter_members m on t.uid=m.uid group by uid order by sum(t.s) desc limit 0,500;
最後更新：2017-04-02 06:52:12