I have a USERS table I use for my site. I have integrated a forum with my site, and therefore have a USER_FORUM table that has the duplicated user info...so, 2 tables with some of the same info.
I would like to put an UPDATE trigger on the USER_FORUM table, so that if the user updates their email address, username, or password through the forum, the trigger will also update the user registration table with the same information.
1) Will this work? I think it will, just need some confirmation
2) I'm new to triggers, how do I do this ONLY for an UPDATE?
3) How do I make the trigger so that it knows if the email, username, or password was changed? I don't need the trigger to do anything if these fields don't change.
If anyone has some example code, I would greatly appreciate it!