問題描述：

當(dāng)我們在使用mysql進(jìn)行數(shù)據(jù)查取的時(shí)候，往往會(huì)涉及臨時(shí)表的功能，但是當(dāng)一個(gè)query語句中，如果使用了多個(gè)臨時(shí)表，會(huì)報(bào)錯(cuò)1146，對于這個(gè)問題應(yīng)該如何解決？

解決思路：

• 可以采取創(chuàng)建多個(gè)臨時(shí)表的思路予以解決，也就是把子查詢結(jié)果封裝為新的臨時(shí)表（create temporary table xxx as (子查詢)）

#drop temporary table tem;


create temporary table tem(
?????? OrderID int,
??? Userid int,
??? primary key(OrderID,Userid)
);


insert into tem
?????? select o.OrderID,o.UserID from orderinfo o;
??? 
select * from tem limit 3;
select * from tem_new limit 3;


create temporary table tem_new as(select OrderID from new_tem order by OrderID limit 20,3) ;


select * 
?????? from tem 
?????? inner join tem_new using (OrderID);#on tem.OrderID=tem_new.OrderID