CREATE VIEW netcheck.cpu_mp AS
(选择
cpu.ID AS id,
cpu.chanel_name AS chanel_name,
CPU.first _ channelasfirst _ channel,
cpu.IMG_Url AS IMG_Url,
CPU.lastmodifytimeaslastmodifytime,
CPU.second _ channelassecond _ channel,
cpu.SHOW_TIME AS SHOW_TIME,
cpu.TASK_Id AS TASK_Id,
cpu.TITLE AS TITLE,
cpu.URL AS URL,
CPU.checksystaskidaschecksystaskid,
cpu.innerUUID AS innerUUID,
cpu.isReject AS isReject,
cpu.scanTime AS scanTime
from channel _ page _ update _ result CPU
) )
全部合并
(选择
mp.id AS id,
' ' AS chanel_name,
' ' AS first_channel,
' ' AS second_channel,
' ' AS TITLE,
mp.imgUrl AS IMG_Url
、MP.lastmodifytimeaslastmodifytime、
mp.showTime AS SHOW_TIME,
mp.taskId AS TASK_Id,
mp.url AS URL,
MP.checksystaskidaschecksystaskid,
mp.innerUUID AS innerUUID,
mp.isReject AS isReject,
mp.scanTime AS scanTime
来自MP
); 再分享一次我的老师大神人工智能教程吧。 零度基点! 很容易理解! 幽默感! 还带有黄色段子! 希望你也加入我们的人工智能团队! https://blog.csdn.net/jiangjun show