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
);
最新文章
- mac rvm升级ruby
- JS仿淘宝星星评价
- Dojo的subscribe和publish的简单使用
- AttributeError: 'list' object has no attribute 'write_pdf'
- 【python】迭代器&;生成器
- Activity启动模式
- (基础篇)echo、print、print_r、printf、sprintf、var_dump的区别比较
- 基于redis分布式缓存实现
- OpenCV图像处理中常用函数汇总(1)
- ActiveMQ(5.10.0) - Spring Support
- 译文: async/await SynchronizationContext 上下文问题
- 基于visual Studio2013解决C语言竞赛题之1077大数相加
- (转)java匿名内部类详解
- static 静态与非静态的区别
- Mac 系统重新安装的几种方法
- Go 语言极速入门
- Java课程寒假之开发记账本软件(网页版)之二
- 光速搭lvs + keepalived + nginx
- PowerShell工作流学习-4-工作流中重启计算机
- BZOJ5337 [TJOI2018] 碱基序列 【哈希】【动态规划】