各位好,我在mysql中写查询代码,中间建了临时表,结果一共有28条,但是查询页面结果只显示25条数据,当我点选显示全部或者点导出时,提示信息临时表XXX不存在,这个怎么办?有没有好的办法解决问题,如果很复杂的代码最好是中间建临时表的方法才更方便
代码:CREATE temporary table douyin_sale_tmp
as
select author,'douyin' as plat
,sum(case when from_unixtime(Saletime)<timestamp('2021-01-28') then pay_gmv else 0 end) as today_sale
,sum(case when from_unixtime(Saletime)<timestamp(date('2021-01-28')-1) then pay_gmv else 0 end) as yesterday_sale
from xbtt_db.day_dy_doudian_usersale
group by 1,2