本文共 305 字，大约阅读时间需要 1 分钟。

SELECT	* FROM	(		( SELECT 'ip' AS type, id, ip_addr AS title, threat_type, CONCAT( inform_date ) AS date FROM threat_ip_db ) UNION		( SELECT 'url' AS type, id, url AS title, threat_type, CONCAT( inform_date ) AS date FROM threat_url_db ) 	) AS c ORDER BY	date DESC 	LIMIT 20 OFFSET 0

通过UNION关键字将两个查询结果拼接起来

转载地址：https://kaisarh.blog.csdn.net/article/details/117752865 如侵犯您的版权，请留言回复原文章的地址，我们会给您删除此文章，给您带来不便请您谅解！