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 <roberto@spadim.com.br> 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     : maria-discuss@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-discuss
More help   : https://help.launchpad.net/ListHelp