+1, work Thanks again justin! Happy new year :) Em terça-feira, 9 de fevereiro de 2016, Justin Swanhart <[email protected]> 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 <[email protected] > <javascript:_e(%7B%7D,'cvml','[email protected]');>> 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 <[email protected] >> <javascript:_e(%7B%7D,'cvml','[email protected]');>> 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 : [email protected] >>> <javascript:_e(%7B%7D,'cvml','[email protected]');> >>> Unsubscribe : https://launchpad.net/~maria-discuss >>> More help : https://help.launchpad.net/ListHelp >>> >>> >> > -- Roberto Spadim SPAEmpresarial - Software ERP Eng. Automação e Controle
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
