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!
Asked
Active
Viewed 79 times
0
-
1you are looking for triggers – Panther Jul 21 '15 at 05:43
-
You can create a trigger to do this – Ammadu Jul 21 '15 at 05:47
-
possible duplicate of [mysql after insert trigger which updates another table's column](http://stackoverflow.com/questions/16892070/mysql-after-insert-trigger-which-updates-another-tables-column) – Aman Aggarwal Jul 21 '15 at 06:15
2 Answers
1
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
Mukesh Kalgude
- 4,742
- 2
- 16
- 32
0
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
Aman Aggarwal
- 16,184
- 9
- 53
- 77