← Back to team overview

maria-discuss team mailing list archive

Re: doubt how to create big query

 

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@xxxxxxxxxxxxx>
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@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~maria-discuss
> More help   : https://help.launchpad.net/ListHelp
>
>

Follow ups

References