| SGreen@unimin.com 2005-09-29, 8:23 pm |
| --=_alternative 007654988525708B_=
Content-Type: text/plain; charset="US-ASCII"
Nick Hird <nrhird@gmail.com> wrote on 09/29/2005 05:03:53 PM:
> Is there a way to have foreign keys and force referential integrity? I
have
> a main table and a lookup table, i want to be able to require that the
main
> table is using values from the lookup table. I am just not sure how in
> MySQL. Thanks
Obviously you are new. Please do not take this the wrong way. We love to
help people that are truly stuck, however you seem to be just a bit under
informed about what MySQL can do. Please, allow me to help you to RTFM:
http://dev.mysql.com/doc/mysql/en/index.html
If you look in the index or use the search feature for Foreign Key, you
will find what you need. IF you can't understand what you read. Please
come back and post another question to the list and I or anyone else will
be very glad to help.
With respect,
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
--=_alternative 007654988525708B_=--
|