ProtectedVoid
Reputation: 1315
SQL Insert row in related when a row is inserted in master
After setting a foreign key relation we can select the action to perform when the row is deleted/updated in master table (foreign key origin).
My question is:
Can I set a relation so when a record is inserted in a master table all related tables insert a new row with the foreign key? I'm looking for this solution because it would be really safer to create records with dependancies. I'm already creating this tree of dependant records manually using PHP.
Thanks in advance.
Upvotes: 0
Views: 30
Answers (1)
Mihai Ovidiu Drăgoi
Reputation: 1317
You are basically describing a trigger, so please read https://dev.mysql.com/doc/refman/5.7/en/trigger-syntax.html
Hope that helps.
Upvotes: 1
Related Questions
- How to add or insert foreign key value in child table from parent table using insert statement
- how to insert child table first, then parent table in mysql
- SQL Insert select with dependency on other table
- MYSQL How to update child table value with foreign key while insert data based on parent table
- Mysql. How to insert row to child table with null value of column that is foreign key
- Trigger insert on related table mysql
- Mysql: insert a new row in a child table with new values except for foreign key column which is obtained from parent table
- INSERT row based on relationship MYSQL
- insert child mysql
- Inserting data into a child table based on master table primary key values