n/5.5/en/partitioning.html which the optimizer
> should be able to take advantage of.
>
> From: Maria-discuss
> [mailto:maria-discuss-bounces+rhys.campbell=swisscom@lists.launchpad.net]
> On Behalf Of Roberto Spadim
> Sent: Wednesday, September 23, 2015 4:06 AM
> To: Maria
[mailto:maria-discuss-bounces+rhys.campbell=swisscom@lists.launchpad.net]
>> On Behalf Of Roberto Spadim
>> Sent: Wednesday, September 23, 2015 4:06 AM
>> To: Maria Discuss
>> Subject: [Maria-discuss] doubt about merge table (1+) with same structure
>>
ally, it would be a good idea to merge all your data into a single
> table. Perhaps use partitioning
> https://dev.mysql.com/doc/refman/5.5/en/partitioning.html which the
> optimizer should be able to take advantage of.
>
>
>
> *From:* Maria-discuss [
> mailto:maria-discuss-boun
: Maria-discuss
[mailto:maria-discuss-bounces+rhys.campbell=swisscom@lists.launchpad.net]
On Behalf Of Roberto Spadim
Sent: Wednesday, September 23, 2015 4:06 AM
To: Maria Discuss
Subject: [Maria-discuss] doubt about merge table (1+) with same structure
Hi again guys :)
i'm with a new problem
Hi again guys :)
i'm with a new problem
i have MANY (1+) tables with same struct, and i want to execute a
select from "some" (100+) tables
i was thinking about creating a view with all tables, something like:
CREATE VIEW view_name AS
SELECT * FROM table1 WHERE primary_key=
UNION ALL
SELECT
5 matches
Mail list logo