Posts by Raphael • 25 points
3 posts
-
0
votes0
answers35
viewsQ: Mysql foreign key creation problem
I am trying to implement a 1:1 relationship between the Employee table and the User table, in Mysql Workbench, but when generating the Diagram I see that the relationship always remains at 1:n, even…
-
1
votes2
answers71
viewsQ: Adding fields between different tables in Mysql
I have the following structure: BUYING id_compra desc_compra valortotal_compra data_compra id_colaborador COMPRAPROD id_compraprod id_compra id_produto qtd_compraprod valorunit_compraprod…
-
1
votes1
answer435
viewsQ: How to insert ON DELETE and ON UPDATE
I have a database structure MySQL ready, but the ALTER TABLE of FOREIGN KEY's did not specify settings for ON DELETE and ON UPDATE. How do I enter these settings now, with tables and keys already…