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_helpe...
--Justin
On Mon, Feb 8, 2016 at 7:03 PM, Roberto Spadim
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
? --- Roberto Spadim
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp