madvalpreston
Technical User
Hi
I created tables in MYsql (I am fairly new to Mysql) and used the workbench.
I find I have a couple of problems which i hope some of you can advise me on.
1. I created all the relationsips using the EER in the workbench. This is ok (I think), but when I have added a new table in (not using the EER model, but directly into the DB) it does not show on the table within the EER model. How can I get my new tables to show up for me so i can add them into the EER OR do i have to always add new tables within the EER model
2. because I cannot add the tables, how can i set up the relationships between the new and exisiting tables and also see that they are related ok.
I have all the tables linked into Access and I suppose I could line within Access but probably not the best way to go.
Thanks for any advice in advance.
I created tables in MYsql (I am fairly new to Mysql) and used the workbench.
I find I have a couple of problems which i hope some of you can advise me on.
1. I created all the relationsips using the EER in the workbench. This is ok (I think), but when I have added a new table in (not using the EER model, but directly into the DB) it does not show on the table within the EER model. How can I get my new tables to show up for me so i can add them into the EER OR do i have to always add new tables within the EER model
2. because I cannot add the tables, how can i set up the relationships between the new and exisiting tables and also see that they are related ok.
I have all the tables linked into Access and I suppose I could line within Access but probably not the best way to go.
Thanks for any advice in advance.