+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_helper.sql

--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