How to auto insert values from TBL_PACKAGE into foreign key on TBL_MEMBER?
Example : If I have two tables like :
TBL_MEMBER
+----+-----------+---------------+-----------------+
| ID | USER_NAME | PACKAGE_ID_FK | UPDATE_TIMES_FK |
+----+-----------+---------------+-----------------+
| No data available in table |
+----+-----------+---------------+-----------------+
TBL_PACKAGE
+----+--------------+--------------+
| ID | PACKAGE_NAME | UPDATE_TIMES |
+----+--------------+--------------+
| 1 | FREE | 5 |
| 2 | PREMIUM | 10 |
+----+--------------+--------------+
When USER1 has been registered USER1 will be gets FREE package Then PACKAGE_ID_FK will auto insert value into 1 and UPDATE_TIMES_FK auto insert value into 5.
TBL_MEMBER should look like this :
+----+-----------+---------------+-----------------+
| ID | USER_NAME | PACKAGE_ID_FK | UPDATE_TIMES_FK |
+----+-----------+---------------+-----------------+
| 1 | USER1 | 1 | 5 |
+----+-----------+---------------+-----------------+
And when registered user buy a PREMIUM package that will auto set PACKAGE_ID_FK value into 2 and UPDATE_TIMES_FK value into 10.
TBL_MEMBER should look like this after USER1 buy a PREMIUM package :
+----+-----------+---------------+-----------------+
| ID | USER_NAME | PACKAGE_ID_FK | UPDATE_TIMES_FK |
+----+-----------+---------------+-----------------+
| 1 | USER1 | 2 | 10 |
+----+-----------+---------------+-----------------+
