22,210
社区成员
发帖
与我相关
我的任务
分享
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
;