SELECT * FROM (
SELECT 'collect_log' AS '表名',id, rsync_status AS '状态', error AS '错误'
FROM universal_etl_range.`collect_log`
WHERE (collect_status = 3 OR compress_status = 3 OR rsync_status = 2)
LIMIT 1
UNION ALL
SELECT 'load_log' AS '表名',id, load_status AS '状态', error AS '错误'
FROM universal_etl_range.`load_log`
LIMIT 3
SELECT 'collect_log' AS '表名',id, rsync_status AS '状态', error AS '错误'
FROM universal_etl_range.`collect_log`
WHERE (collect_status = 3 OR compress_status = 3 OR rsync_status = 2)
LIMIT 1
UNION ALL
SELECT 'load_log' AS '表名',id, load_status AS '状态', error AS '错误'
FROM universal_etl_range.`load_log`
LIMIT 3
) tmp LIMIT 100;
结果:1表1条数据,2表3-1=2条数据