MySQL Forums
Forum List  »  MySQL Workbench

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

Hi,

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.

Thanks,

Options: ReplyQuote


Subject
Views
Written By
Posted
Modifying existing database
85
November 10, 2017 03:14AM
33
November 10, 2017 11:04AM
38
November 10, 2017 12:19PM
41
November 10, 2017 02:53PM


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.