方法一:
create view CAB_OP_VIEW AS
select * from t_cab_op_202209
union all
select * from t_cab_op_202210
union all
select * from t_cab_op_202211;
select * from CAB_OP_VIEW where create_time between '2022-11-01' and '2022-11-19' limit 10;
方法二:
select * from (
select * from t_cab_op_202209 union
select * from t_cab_op_202210 union
select * from t_cab_op_202211
) t
where t.cab_code='221134310006' and t.create_time between '2022-09-01' and '2022-11-19' order by t.create_time asc limit 10;
方法三:使用mycat