MySQL Forums
Forum List  »  Views

combing tables which all have the same fields
Posted by: James Cochr
Date: July 20, 2017 08:35AM

I would like to add lots of tables which have the same fields and index together to create a new table with all the fields combined together with new names associated with the table from which they came. I understand that Full Outer Join is problematic in MYSQL and wondered if there was a quicker way as all the tables are the same length and structure. Is it possible?

Table 1
Index A B C
1 1 6 3
2 3 2 7
...

Table 2
Index A B C
1 3 5 5
2 6 4 5
...

Table 3
...

View/Table/Output
Index A1 B1 C1 A2 B2 C2 ...
1 1 6 3 3 5 5 ...
2 3 2 7 6 4 5 ...
...


What is the best of doing this?

Options: ReplyQuote


Subject
Views
Written By
Posted
combing tables which all have the same fields
955
July 20, 2017 08:35AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.