Mysql 多个子查询 多个LEFT JOIN 视图创建
来源:互联网 发布:网络段子精选哲理 编辑:程序博客网 时间:2024/05/16 06:07
CREATE VIEW `v_noprovide` AS SELECT*FROMtb_sectionWHEREprovide = '0'CREATE VIEW `v_thismonth` AS SELECTts.userId AS id,CONCAT('thismonth:',SUM(ts.amount),'yuan') AS 'thismonth'FROMtb_section AS tsWHEREts.yearMonth = DATE_FORMAT(NOW(), '%Y%m')CREATE VIEW `v_lastmonth` AS SELECTts.userId AS id,CONCAT('lastmonth:',SUM(ts.amount),'yuan') AS 'lastmonth'FROMtb_section AS tsWHEREts.yearMonth = DATE_FORMAT(DATE_SUB(NOW(), INTERVAL 1 MONTH),'%Y%m')CREATE VIEW `v_usermanage` ASSELECTu.id AS id,u.email AS email,u.`name` AS `name`,CONCAT(COALESCE (la.lastmonth,'lastmonth:0yuan'),COALESCE (th.thismonth,'thismonth:0yuan')) AS recent,Sum(COALESCE(b.amount,0)) AS totalBonus,Sum(COALESCE(n.amount,0)) AS unbilledFROMtb_user AS uLEFT JOIN tb_bonus AS b ON u.id = b.receiverIdLEFT JOIN v_noprovide AS n ON u.id = n.userIdLEFT JOIN v_thismonth AS th ON u.id = th.idLEFT JOIN v_lastmonth AS la ON u.id = la.idGROUP BY u.id
1 0
- Mysql 多个子查询 多个LEFT JOIN 视图创建
- Mysql 多个子查询 多个LEFT JOIN 视图创建
- mysql多个left join
- MySQL多表连接查询Left Join,Right Join
- MySQL多表连接查询Left Join,Right Join
- 【转】MySQL多表连接查询Left Join,Right Join
- mysql多表连接查询inner join, left join , right join ,full join ,cross join
- Mysql多个LEFT JOIN使用ORDER不能使用索引导致查询过慢的解决方案
- Mysql多个LEFT JOIN使用ORDER不能使用索引导致查询过慢的解决方案
- Mysql多个LEFT JOIN使用ORDER BY不能使用索引导致查询过慢的解决方案
- mysql中的left join用法 (及多条件查询
- Mysql多表left join查询
- MySQL多表连接查询Left Join,Right Join(讲的一般般)
- 针对于多个inner join或者left join多条件查询的时候,各个inner join 的指向问题
- Left join与简单多表查询
- 多表级联查询(left join)
- 多个left join 怎么执行?
- 数据库多个left join如何执行
- CMake find_package for OpenCV
- 控制输出精度
- 『算法学习笔记』11th day. 文件操作<2>
- 执行计划中各个字段的含义描述及获取方法
- 线程同步
- Mysql 多个子查询 多个LEFT JOIN 视图创建
- 数据结构 -- 二叉树中序遍历
- tomcat加载web.xml
- HDU 1271
- 创业型团队需要的云计算
- 有趣的linux命令
- POJ - Fibonacci 【快速幂 + 矩阵】
- OC之内存管理
- 18 MySQL加锁处理分析