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
858
November 10, 2017 03:14AM
330
November 10, 2017 11:04AM
346
November 10, 2017 12:19PM
368
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.