maria-discuss team mailing list archive
Mailing list archive
Re: doubt how to create big query
Thanks again justin! Happy new year :)
Em terça-feira, 9 de fevereiro de 2016, Justin Swanhart <greenlion@xxxxxxxxx>
> 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:
> On Mon, Feb 8, 2016 at 9:46 PM, Justin Swanhart <greenlion@xxxxxxxxx
>> 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:
>> On Mon, Feb 8, 2016 at 7:03 PM, Roberto Spadim <roberto@xxxxxxxxxxxxx
>>> 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
SPAEmpresarial - Software ERP
Eng. Automação e Controle