MySQL Performance: MySQL => PRIMARY KEY or FOREIGN KEY?

Members

Help

Home

Home » Performance » MySQL » PRIMARY KEY or FOREIGN KEY?

Show: Today's Messages :: Show Polls :: Message Navigator

PRIMARY KEY or FOREIGN KEY? [message #1456]

Thu, 21 June 2007 20:29

omakase
Messages: 3
Registered: June 2007

Junior Member

Say I have a users table with uid, name, email, and password with a PRIMARY KEY on uid and a UNIQUE KEY on email.

Now I want to create a profiles table with uid, and other extended profile information. Should uid be a PRIMARY KEY or a FOREIGN KEY referencing uid from users in this case?

Report message to a moderator

[Message index]

Read Message PRIMARY KEY or FOREIGN KEY?
By: omakase on Thu, 21 June 2007 20:29

Re: PRIMARY KEY or FOREIGN KEY?
By: babuno5 on Fri, 22 June 2007 06:20

Re: PRIMARY KEY or FOREIGN KEY?
By: omakase on Fri, 22 June 2007 09:27

Re: PRIMARY KEY or FOREIGN KEY?
By: babuno5 on Fri, 22 June 2007 15:29

Read Message Re: PRIMARY KEY or FOREIGN KEY?
By: carpii on Sun, 24 June 2007 15:27

Previous Topic: Mysql Server tuning

Next Topic: InnoDB Backup

Goto Forum:

-=] Back to Top [=-

[ Generate printable PDF ] [ Syndicate this forum (XML) ] [

]

Current Time: Thu Jul 9 21:34:33 EDT 2009

Total time taken to generate the page: 0.02123 seconds

.:: Contact :: Home ::.

MySQL is a trademark of Sun Microsystems.
InnoDB is a trademark of Oracle Corp.

Percona Performance Forums are a service of Percona, Inc.
Not affiliated with Sun Microsystems or Oracle Corp.