mysql视图union all效率_MySQL创建视图和Union all的使用案例-阿里云开发者社区

MySQL创建视图和Union all的使用案例

涂作权

2015-04-13

900浏览量

简介：



CREATE VIEW netcheck.cpu_mp AS

(SELECT

cpu.ID AS id,

cpu.chanel_name AS chanel_name,

cpu.first_channel AS first_channel,

cpu.IMG_Url AS IMG_Url,

cpu.lastModifyTime AS lastModifyT



CREATE VIEW netcheck.cpu_mp AS

(SELECT

cpu.ID AS id,

cpu.chanel_name AS chanel_name,

cpu.first_channel AS first_channel,

cpu.IMG_Url AS IMG_Url,

cpu.lastModifyTime AS lastModifyTime,

cpu.second_channel AS second_channel,

cpu.SHOW_TIME AS SHOW_TIME,

cpu.TASK_Id AS TASK_Id,

cpu.TITLE AS TITLE,

cpu.URL AS URL,

cpu.checkSysTaskId AS checkSysTaskId,

cpu.innerUUID AS innerUUID,

cpu.isReject AS isReject,

cpu.scanTime AS scanTime

FROM channel_page_update_result cpu

)

UNION ALL

(SELECT

mp.id AS id,

'' AS chanel_name,

'' AS first_channel,

'' AS second_channel,

'' AS TITLE,

mp.imgUrl AS IMG_Url

,mp.lastModifyTime AS lastModifyTime,

mp.showTime AS SHOW_TIME,

mp.taskId AS TASK_Id,

mp.url AS URL,

mp.checkSysTaskId AS checkSysTaskId,

mp.innerUUID AS innerUUID,

mp.isReject AS isReject,

mp.scanTime AS scanTime

FROM mainpageupdateresult mp

);

关系型数据库

MySQL

版权声明：本文内容由阿里云实名注册用户自发贡献，版权归原作者所有，阿里云开发者社区不拥有其著作权，亦不承担相应法律责任。具体规则请查看《阿里云开发者社区用户服务协议》和《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容，填写侵权投诉表单进行举报，一经查实，本社区将立刻删除涉嫌侵权内容。

分享：