ID update with various tables

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
bharanidharanit
Forum Newbie
Posts: 15
Joined: Sun Jan 03, 2010 9:13 pm

ID update with various tables

Post by bharanidharanit »

Hello,
In facebook, or any other social networking websites. How are they really linking tables. I think they mostly does by ID. So when the users registers with register table, how to update the ID simultaneously with other tables like login,scrapbook,friendlist etc.?
User avatar
Christopher
Site Administrator
Posts: 13596
Joined: Wed Aug 25, 2004 7:54 pm
Location: New York, NY, US

Re: ID update with various tables

Post by Christopher »

I am not clear what "when the users registers with register table" means, but usually you use and internal ID -- not the ID that the user enters.
(#10850)
bharanidharanit
Forum Newbie
Posts: 15
Joined: Sun Jan 03, 2010 9:13 pm

Re: ID update with various tables

Post by bharanidharanit »

arborint wrote:I am not clear what "when the users registers with register table" means, but usually you use and internal ID -- not the ID that the user enters.
Hi suppose when the users registers with the username and password, ID is automatically created with autonumber and the record is updated. After once the record is created in the register table, how to update the other tables, for the current user?
Post Reply