Design the two tables, a student, a user, the user table with id, username and password, more student name and phone,
Want to modify the user table, student corresponding properties follow change, modify the student table, the user corresponding properties follow change,
Checked the trigger, also can achieve, one-way, I changed my user table, for example, student table will follow to change, but not in reverse, and shall not create one to two trigger, this how to solve the synchronization of two-way,