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

首先给大家分享一个巨牛巨牛的人工智能教程，是我无意中发现的。教程不仅零基础，通俗易懂，而且非常风趣幽默，还时不时有内涵段子，像看小说一样，哈哈～我正在学习中，觉得太牛了，所以分享给大家！点这里可以跳转到教程

               



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

浏览人工智能教程