← Back to team overview

maria-discuss team mailing list archive

doubt how to create big query


hi guys
i'm with a problem / possible feature request

i have many tables with same structure (same fields) and i need to create a
big query with all tables

something like:

select * from t1
union all
select * from t2
union all
select * from .....
... union all
select * from t99999

is there anyway to create a big query with some "template c++ like"
feature? something like

select * from <union all t1, t2, t3, t3, t4....> ?

Roberto Spadim

Follow ups