maria-discuss team mailing list archive

[Justin Swanhart <greenlion@xxxxxxxxx>]

Hi,

Actually ps_history (my performance schema periodic capture tool) uses a
constructed UNION to get a consistent snapshot of the performance schema.
It might be more useful to you:
https://github.com/greenlion/ps_history/blob/master/setup.sql

--Justin

On Mon, Feb 8, 2016 at 9:46 PM, Justin Swanhart <greenlion@xxxxxxxxx> wrote:

> 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@xxxxxxxxxxxxx>
> 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@xxxxxxxxxxxxxxxxxxx
>> Unsubscribe : https://launchpad.net/~maria-discuss
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>