union查询
2024-09-03 23:38:05
select id, uid, money, FROM_UNIXTIME(created) as created, type FROM
(
#type=1是 cjw_finance_bonus查出的内容
select id, uid,balance as money, '1' as type, created FROM cjw_finance_bonus
WHERE uid = 281
union all
#type=12是 cjw_qb_cashuser查出的内容
select id, uid,money, '2' as type, createtime as created FROM cjw_qb_cashuser
WHERE uid = 281
)tmp ORDER BY created DESC
(
#type=1是 cjw_finance_bonus查出的内容
select id, uid,balance as money, '1' as type, created FROM cjw_finance_bonus
WHERE uid = 281
union all
#type=12是 cjw_qb_cashuser查出的内容
select id, uid,money, '2' as type, createtime as created FROM cjw_qb_cashuser
WHERE uid = 281
)tmp ORDER BY created DESC
最新文章
- Mysql中eft join、right join、inner join的区别
- 模拟提交API数据Pyqt版
- 登录phpmyadmin提示: #1045 无法登录 MySQL 服务器
- 20145320《Java程序设计》第4周学习总结
- jQuery UI dialog
- Win8 Cisco VPN Client 442错误解决办法
- ld链接问题解决
- Samba 4.x.x全版本存在命令执行漏洞
- 服务器卡死,重启报错: INFO: task blocked for more than 120 seconds
- HTML 简单了解
- 在OQL上使用UPDLOCK锁定查询结果,安全的更新实体数据
- 读Vue源码 (依赖收集与派发更新)
- 【MySQL】5.6.x InnoDB Error Table mysql.innodb_table_stats not found
- [LeetCode] 29. Divide Two Integers(不使用乘除取模,求两数相除) ☆☆☆
- struts2 中怎样获取HttpServletReqest
- git基本操作,一篇文章就够了!
- RequireJS 是一个JavaScript模块加载器
- LA 7272 Promotions(dfs)
- MyCat入门指南
- 在 FastAdmin 中启动 ThinkPHP 5 的请求缓存分析