摘要:
select ma.cnt1 as "上周注册用户总数",ma.cnt2 as "上周活跃用户数",ma.cnt3 as "本周活跃用户数",cast (ma.cnt3 as double)/ma.cnt1 as "新用户留存率",cast(ma.cnt3 as double)/ma.cnt2 as 阅读全文
摘要:
由于mysql8.0开启gtid复制环境以后,建表不能再ctas了,以前oracle数据库一直可以ctas,很方便,就想了下怎么实现mysql下这个功能,找到一种方法: USE report; SET sql_require_primary_key=0; CREATE TEMPORARY TABLE 阅读全文