Unanswered: ID update with various tables in a database
I am using login table and user table. When i add some datas in login table, that corresponding ID(Autonumber field) from login table must be updated with user table.
How to perform this? This must handles for very large number of users.
Again in a social networking website, they have profile pages, scrapbook, friendlist, photos etc. This must be different among every users. They must have different tables. How are they linking every tables? If mostly by id, how to link every tables, after a user registration?
i am having tbl_users and tbl_profile tables. After a new record created in tbl_users, i want to get tbl_users.id and insert that id in a profile table. I used this coding, but i know how to retrieve id from tbl_users to a tbl_profile table?
Here's my coding,
create trigger update_id
after update on tbl_users
for each row begin