Two fields between different tables how to associate inserts

The User table field has

ID username Password e-mail

The Mibao table field has

ID e-mail Q1 Q2 Q3

The effect I want to achieve is to keep the E-mail fields of the user table and the security table consistent, how should this be done?
Do you have anything else to improve on creating a table? Ask the Great God ~ ~ ~


My ultimate goal is to pass the mailbox verification after jump to the secret protection page fill in the secret security to obtain the password.

Reply to discussion (solution)

Consider using foreign keys, but there are too many constraints that you may not be able to manage
You can also consider using triggers
The simple point is to insert the Mibao table immediately after inserting the user table

Consider using foreign keys, but there are too many constraints that you may not be able to manage
You can also consider using triggers
The simple point is to insert the Mibao table immediately after inserting the user table

How to achieve it? Insert the Mibao table after the email field is inserted into the user table ...

Email is inserted in the User table and Mibao table when registering, you should be the ID of UserID why not in a table?

