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

最新推荐文章于 2024-09-09 21:55:29 发布

原创最新推荐文章于 2024-09-09 21:55:29 发布 · 8.9k 阅读

0 ·

CC 4.0 BY-SA版权

MySQL 专栏收录该内容

32 篇文章

订阅专栏

本文介绍如何创建视图以整合CPU信息与主要页面更新结果，包括ID、通道名称、首次与二次通道、图片URL、最后修改时间、显示时间、任务ID、网址、检查系统任务ID、内部UUID、是否拒绝以及扫描时间。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

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
);