maria-discuss team mailing list archive

[Justin Swanhart <greenlion@xxxxxxxxx>]

Hi,

Happy to help!

--Justin

On Tue, Feb 9, 2016 at 5:28 PM, Roberto Spadim <roberto@xxxxxxxxxxxxx>
wrote:

> +1, work
> Thanks again justin! Happy new year :)
>
>
> Em terça-feira, 9 de fevereiro de 2016, Justin Swanhart <
> greenlion@xxxxxxxxx> escreveu:
>
>> 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
>>>>
>>>>
>>>
>>
>
> --
> Roberto Spadim
> SPAEmpresarial - Software ERP
> Eng. Automação e Controle
>
>