如何自动更新联结表并从联结表访问数据？

Question

Now I have 2 tables: demo(detailed information about users) and users(login and password), then I create a junction table(ID, demo_ID and user_ID). The system working like this:

1. User register
2. User login
3. User fill form where he gave a detailed information

And I want to fill junction table automatically with user_ID and demo_ID where user_ID will LOGGED USER and demo_ID the information of exactly this user.

How can I do this? Please help me =)

Answer 1

You can use query like -

INSERT INTO rel_users_demo (demo_ID,users_ID) SELECT demo.ID, users.ID join on demo.EMail = users.email

You have not mentioned which column you have in common(foreign key) between demo and users. you can keep your column at place of xx and yy.