mysql - When I insert a row, update a column in a different table -


is possible in mysql create kind of rule table when insert new row table, updates column in separate table?

thank you!

yes possible. can use trigger.you can create trigger insert on table , updated value second table.

more details trigger refer link

https://dev.mysql.com/doc/refman/5.0/en/trigger-syntax.html


Comments