Hi, Happy to help! --Justin On Tue, Feb 9, 2016 at 5:28 PM, Roberto Spadim <roberto@spadim.com.br> wrote:
+1, work Thanks again justin! Happy new year :)
Em terça-feira, 9 de fevereiro de 2016, Justin Swanhart < greenlion@gmail.com> 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@gmail.com> 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_helpe...
--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
-- Roberto Spadim SPAEmpresarial - Software ERP Eng. Automação e Controle