mysql同时查询多张天表的数据

最新推荐文章于 2022-12-31 19:18:30 发布

原创最新推荐文章于 2022-12-31 19:18:30 发布 · 216 阅读

0 ·

CC 4.0 BY-SA版权

MySql 专栏收录该内容

3 篇文章

订阅专栏

本文深入探讨了使用SQL进行复杂查询的技巧，特别是如何从多个表中根据特定条件（如电话号码）联接并选择数据，然后按时间顺序排序。通过实际代码示例，读者将学习到如何高效地从数据库中检索信息。

select
a.id AS "id",
a.phone AS "phone",
a.current_temp AS "currentTemp",
a.longitude AS "longitude",
a.latitude AS "latitude",
a.time AS "time"
from ${tableName1} a
where a.phone=#{phone}
union select
b.id AS "id",
b.phone AS "phone",
b.current_temp AS "currentTemp",
b.longitude AS "longitude",
b.latitude AS "latitude",
b.time AS "time"
from ${tableName2} b
where b.phone=#{phone}
union select
c.id AS "id",
c.phone AS "phone",
c.current_temp AS "currentTemp",
c.longitude AS "longitude",
c.latitude AS "latitude",
c.time AS "time"
from ${tableName3} c
where c.phone=#{phone}
ORDER BY time