Hi, Use a stored procedure to construct the union as from a CSV list of tables and execute it using a prepared statement. Stored routines can return resultsets.
Look at sq_helper.sql in Shard-Query for hints: https://github.com/greenlion/swanhart-tools/blob/master/shard-query/sq_helper.sql --Justin On Mon, Feb 8, 2016 at 7:03 PM, Roberto Spadim <[email protected]> wrote: > 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 > > _______________________________________________ > Mailing list: https://launchpad.net/~maria-discuss > Post to : [email protected] > Unsubscribe : https://launchpad.net/~maria-discuss > More help : https://help.launchpad.net/ListHelp > >
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
