Mysql 数据仓库 SQL 查询请帮忙

发布于 2024-12-06 10:00:12 字数 276 浏览 2 评论 0原文

我有以下数据库，

db: exam_2011
tables: score_01, score_02, score_03.....score_12

db: exam_2012
tables: score_01, score_02, score_03.....score_12

数据库是年份，表是月份；

如何获取2011年7月1日至2012年2月2日期间的数据？

请帮助构建查询。数据库服务器是mysql。谢谢。这不是家庭作业或学校的东西。

原文

I have the following database

db: exam_2011
tables: score_01, score_02, score_03.....score_12

db: exam_2012
tables: score_01, score_02, score_03.....score_12

the database is the year and the tables are the month;

How can I get the data between 1 July 2011 to 2 February 2012?

Please help to construct the query. The database server is mysql. Thanks. This is not homework or school stuff.

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

痴骨ら 2024-12-13 10:00:12

我假设这些表中有一个名为 day 的列：

select * from exam_2011.score_07
union all
select * from exam_2011.score_08
union all
select * from exam_2011.score_09
union all
select * from exam_2011.score_10
union all
select * from exam_2011.score_11
union all
select * from exam_2011.score_12
union all
select * from exam_2012.score_01
union all
select * from exam_2012.score_02 where day <= 2

I assume that you have a column named day in these tables:

select * from exam_2011.score_07
union all
select * from exam_2011.score_08
union all
select * from exam_2011.score_09
union all
select * from exam_2011.score_10
union all
select * from exam_2011.score_11
union all
select * from exam_2011.score_12
union all
select * from exam_2012.score_01
union all
select * from exam_2012.score_02 where day <= 2

回复收藏 0 原文

~没有更多了~