MySQL Forums
Forum List  »  MySQL Workbench

Modifying existing database
Posted by: Eran Yasso
Date: November 10, 2017 03:14AM


I have a question about modifying an existing table with data.
I have a database with 4 tables. two tables have many-to-many relation (products and supplier). the relation table is supplier_has_product and free table.
In my test database, I have added fifth tables (category) and it has a one-many relation to products.

My question is, how do I update my production table with the new schema without loosing the data? Can I do it from workbench without script? some kind of wizard?
I'd appreciate if you can share link to video or text.


Options: ReplyQuote

Written By
Modifying existing database
November 10, 2017 03:14AM
November 10, 2017 11:04AM
November 10, 2017 12:19PM
November 10, 2017 02:53PM

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.