+1, work<span></span><div>Thanks again justin! Happy new year :)<br><br>Em terça-feira, 9 de fevereiro de 2016, Justin Swanhart &lt;<a href="mailto:greenlion@gmail.com">greenlion@gmail.com</a>&gt; escreveu:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">Hi,<div><br></div><div>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:<br><a href="https://github.com/greenlion/ps_history/blob/master/setup.sql" target="_blank">https://github.com/greenlion/ps_history/blob/master/setup.sql</a><br></div><div><br></div><div>--Justin</div></div><div class="gmail_extra"><br><div class="gmail_quote">On Mon, Feb 8, 2016 at 9:46 PM, Justin Swanhart <span dir="ltr">&lt;<a href="javascript:_e(%7B%7D,&#39;cvml&#39;,&#39;greenlion@gmail.com&#39;);" target="_blank">greenlion@gmail.com</a>&gt;</span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">Hi,<div><br></div><div>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.</div><div><br></div><div>Look at sq_helper.sql in Shard-Query for hints:<br><a href="https://github.com/greenlion/swanhart-tools/blob/master/shard-query/sq_helper.sql" target="_blank">https://github.com/greenlion/swanhart-tools/blob/master/shard-query/sq_helper.sql</a><br></div><div><br></div><div>--Justin</div></div><div class="gmail_extra"><br><div class="gmail_quote"><div><div>On Mon, Feb 8, 2016 at 7:03 PM, Roberto Spadim <span dir="ltr">&lt;<a href="javascript:_e(%7B%7D,&#39;cvml&#39;,&#39;roberto@spadim.com.br&#39;);" target="_blank">roberto@spadim.com.br</a>&gt;</span> wrote:<br></div></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div><div dir="ltr"><div><div><div><div><div><div><div><div><div><div><div>hi guys<br></div>i&#39;m with a problem / possible feature request<br><br></div>i have many tables with same structure (same fields) and i need to create a big query with all tables<br><br></div>something like:<br><br><br></div>select * from t1<br></div>union all<br></div>select * from t2<br></div>union all <br></div>select * from .....<br></div><div>... union all<br></div>select * from t99999<br><br></div>is there anyway to create a big query with some &quot;template c++ like&quot; feature? something like <br><br></div>select * from &lt;union all t1, t2, t3, t3, t4....&gt; ?<br><div><br>---<br><div><div><div><div><div><div><div><div><div><div><div><div><div dir="ltr"><div><div dir="ltr">Roberto Spadim</div></div></div></div>
</div></div></div></div></div></div></div></div></div></div></div></div></div>
<br></div></div>_______________________________________________<br>
Mailing list: <a href="https://launchpad.net/~maria-discuss" rel="noreferrer" target="_blank">https://launchpad.net/~maria-discuss</a><br>
Post to     : <a href="javascript:_e(%7B%7D,&#39;cvml&#39;,&#39;maria-discuss@lists.launchpad.net&#39;);" target="_blank">maria-discuss@lists.launchpad.net</a><br>
Unsubscribe : <a href="https://launchpad.net/~maria-discuss" rel="noreferrer" target="_blank">https://launchpad.net/~maria-discuss</a><br>
More help   : <a href="https://help.launchpad.net/ListHelp" rel="noreferrer" target="_blank">https://help.launchpad.net/ListHelp</a><br>
<br></blockquote></div><br></div>
</blockquote></div><br></div>
</blockquote></div><br><br>-- <br><div dir="ltr"><div><div dir="ltr">Roberto Spadim<br>SPAEmpresarial - Software ERP<div>Eng. Automação e Controle</div></div></div></div><br>