Is it possible in MySQL to create some kind of rule for a table that when I insert a new row into that table, that it updates a column in a separate table?
Thank you!
3
- 1you are looking for triggersPanther– Panther2015-07-21 05:43:25 +00:00Commented Jul 21, 2015 at 5:43
- You can create a trigger to do thisAmmadu– Ammadu2015-07-21 05:47:31 +00:00Commented Jul 21, 2015 at 5:47
- possible duplicate of mysql after insert trigger which updates another table's columnAman Aggarwal– Aman Aggarwal2015-07-21 06:15:17 +00:00Commented Jul 21, 2015 at 6:15
Add a comment |
2 Answers
Yes it is possible. You can use trigger.You can create trigger insert on table and updated value to second table.
More details for trigger refer this link
Comments
You need to use AFTER INSERT Trigger for the table in which new rows being inserted.
You can check the after insert trigger here:Link
