Foreign Key Question

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
Texan
Forum Newbie
Posts: 9
Joined: Mon Dec 20, 2004 9:23 pm

Foreign Key Question

Post by Texan »

A quick question, I would like to do some finishing touches on my
database. I would like to set up all of my freign keys in my DB.
How do I set these up? I know I should know, but I don't. Are
there any benefits do setting them up?

Thanks
User avatar
Chris Corbyn
Breakbeat Nuttzer
Posts: 13098
Joined: Wed Mar 24, 2004 7:57 am
Location: Melbourne, Australia

Post by Chris Corbyn »

Dude.... if your database is finshed I can't see how you don't have these set up if you need them. It's the almost the first thing you should do.

I guess it's time to read up on database design and Normalization.

Google: "Database normalization"
Texan
Forum Newbie
Posts: 9
Joined: Mon Dec 20, 2004 9:23 pm

Post by Texan »

The project isn't done, I am just doing some test scrips and such to make sure the db
is setup in the best possible way.
Post Reply