MySQL Forums
Forum List  »  Newbie

Re: Do not copy. Create...
Posted by: Владислав Сокол
Date: January 05, 2022 03:01PM

> the new table is meant to ultimately replace the original table

In this case the method with copying the data into new table is not safe itself, and ALTER TABLE must be applied.

> for use in a different schema

Absolutely unclear statement. Simply specify complete table name, including schema (database) name.

> in a set of related tables that are unrelated to the original table

Why? you obtain the table of needed structure with complete data copy. After this you can alter this table and integrate it into new relational scheme. Moreover, this is more suitable method when you need the existing tables in new scheme to refer to this new table.

Options: ReplyQuote

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.