MySQL Forums
Forum List  »  Newbie

Move several fields from multiple tables to a new table
Posted by: Paul Grimes
Date: November 18, 2021 04:49AM

Good Morning.
I have just inherited a database and it has 5 tables which all have the same fields,
For example,
Table Name "OperationsNW" has a unique key of OpsNo
Fields contain Materials01, Materials02, Materials03,

Next Table is
Table Name "OperationsNE" has a unique key of OpsNo
Fields contain Materials01, Materials02, Materials03,
This goes on in the 5 tables, but have many more repeated fields.
I would like to have a separate table called Materials and have Materials01, Materials02, Materials03 but how can I migrate the individual tables from the different Operations tables into Materials?
Thanks

Options: ReplyQuote


Subject
Written By
Posted
Move several fields from multiple tables to a new table
November 18, 2021 04:49AM


Sorry, only registered users may post in this forum.

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.