大数据可以采用子查询

(SELECT record_id,created,1,title,content,learning FROM oa_safetyreport_record where record_id > (select record_id from oa_safetyreport_record limit 200000,1))
union ALL
(SELECT record_id,created,2,title,content,null FROM oa_submission_record where record_id > (select record_id from oa_safetyreport_record limit 200000,1))
-- where created > 1498464558000
order by created
limit 10;

posted @ 2017-07-12 19:20  太空刘  阅读(266)  评论(0编辑  收藏  举报