首页 > 编程知识 正文

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

时间:2023-05-04 21:16:51 阅读:180327 作者:2333

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

版权声明:该文观点仅代表作者本人。处理文章:请发送邮件至 三1五14八八95#扣扣.com 举报,一经查实,本站将立刻删除。