(SELECT * FROM tA ORDER BY update_time DESC)
UNION
(SELECT * FROM tB ORDER BY update_time DESC)
UNION
(SELECT * FROM tC ORDER BY update_time DESC)
ORDER BY update_time DESC LIMIT 5;
UNION
(SELECT * FROM tB ORDER BY update_time DESC)
UNION
(SELECT * FROM tC ORDER BY update_time DESC)
ORDER BY update_time DESC LIMIT 5;
解决方案 »
- MYSQL如何使用connector/net存取byte数组到blob列内?
- mysql的问题(急等)
- 数据库迁徙:是从oracle到mysql容易一些,还是从sql server到mysql容易些?
- 一个大表130万条 ,现在还在增加索引
- 哪位高手帮我看看这查询语句如何写?
- 请问怎样改变MYSQL数据库的字段长?????????????
- 请mysql 高手帮忙看看我的Mysql服务如何优化和注意什么东西,只要解决要多少分数都可以
- mysql双机热备份
- 请教一个建表的问题:比如cpu表(字段不确定)+报价表(每天)
- 如何从多个表中查询到需要的数据
- 如何在进行表更新操作时把表锁定,有这样的命令么? 急!!
- mysql的临时表问题~~100
(SELECT * FROM tA ORDER BY update_time DESC LIMIT 5)
UNION
(SELECT * FROM tB ORDER BY update_time DESC LIMIT 5)
UNION
(SELECT * FROM tC ORDER BY update_time DESC LIMIT 5)
ORDER BY update_time DESC LIMIT 5;