2.mysql 将查询出来的表设置别名用法

来源：互联网发布：立保通软件下载编辑：程序博客网时间：2024/05/05 22:32

需求及代码见下：

</pre><pre name="code" class="sql">INSERT INTO tb_xynrj_detail (sdate,corpid,appid,js_user,yx_user,repeatimei_user,noimsi_user,xz_user) SELECTsdate,corpid,appid,js_user,yx_user,repeatimei_user,noimsi_user,(yx_user + repeatimei_user + noimsi_user) AS xz_userFROM(SELECTsdate,corpid,appid,ROUND((RAND()*0.4+0.8)*(js_user)) AS js_user,ROUND((RAND()*0.4+0.8)*(js_user * yx_ratio)) AS yx_user,ROUND((RAND()*0.4+0.8)*(js_user * repeatimei_ratio)) AS repeatimei_user,ROUND((RAND()*0.4+0.8)*(js_user * noimsi_ratio)) AS noimsi_userFROM(SELECTrep.sdate AS sdate,app.channelid AS corpid,rep.appid as appid,(rep.hcount + rep.mcount + rep.lcount) AS js_user,app.yx_ratio AS yx_ratio,app.noimsi_ratio AS noimsi_ratio,app.repeatimei_ratio AS repeatimei_ratioFROMtbn_appreport AS repINNER JOIN tb_customerapp AS app ON rep.appid = app.idWHEREsdate = '20151202') AS vj) vj2

1 0