MySql 多表，无关联查询

github_36558969 2018-08-29 08:04:45

表A 与表B 字段一致，
现需要获取10条数据，
从A，B表获取创建时间最近的10条数据。

...全文

391 2 打赏收藏转发到动态举报

写回复

用AI写文章

2 条回复

切换为时间正序

请发表友善的回复…

发表回复

吉普赛的歌 2018-08-29

打赏
举报

drop table if exists `A`;

drop table if exists `B`;

CREATE table `A`(

	id int NOT NULL AUTO_INCREMENT,

	create_date datetime not null ,

  PRIMARY KEY (id)

);

CREATE table `B`(

	id int NOT NULL AUTO_INCREMENT,

	create_date datetime not null ,

  PRIMARY KEY (id)

);

insert into `A`(create_date) values('2018-08-29 19:50:51');

insert into `A`(create_date) values('2018-08-29 19:50:51');

insert into `A`(create_date) values('2018-08-29 19:50:51');

insert into `A`(create_date) values('2018-08-29 19:50:51');

insert into `A`(create_date) values('2018-08-29 19:50:51');

insert into `A`(create_date) values('2018-08-29 19:50:51');

insert into `A`(create_date) values('2018-08-29 19:50:51');

insert into `A`(create_date) values('2018-08-29 19:50:51');

insert into `A`(create_date) values('2018-08-29 19:50:51');

insert into `A`(create_date) values('2018-08-29 19:50:51');

#

insert into `B`(create_date) values('2018-08-29 15:34:43');

insert into `B`(create_date) values('2018-08-29 19:35:50');

insert into `B`(create_date) values('2018-08-29 16:36:54');

insert into `B`(create_date) values('2018-08-29 19:53:41');

insert into `B`(create_date) values('2018-08-29 15:10:25');

insert into `B`(create_date) values('2018-08-29 15:42:46');

insert into `B`(create_date) values('2018-08-29 17:41:52');

insert into `B`(create_date) values('2018-08-29 13:24:29');

insert into `B`(create_date) values('2018-08-29 10:12:16');

insert into `B`(create_date) values('2018-08-29 15:15:12');



select * from (

select * from A

union all 

select * from B

) as t

order by t.create_date desc

limit 10

;