|
Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com |
Primary key / foreign key question
From: Steve Grosz (boise_bound
hotmail.com)
Date: Mon Nov 10 2008 - 23:02:02 CST
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Ok, I'm a little new a this, so be gentle!! :)
I was looking into the InnoDB engine for some tables I have, and would like
to use the PK/FK on some of the data.
It appears that the PK/FK is mainly used for updating/deleting data,
correct? I can't use it to retreive data from multiple tables and have them
linked, other than a join? Or am I wrong?
Is there a good visual tool that I can use to build my tables, create the
PK/FK definations, and test how inserts, deletes, updates affect all the
tables involved??
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]