>How do i put in an integrity constraint?
>
>ie. say i have 2 tables
>
>Person (PersonID[pk], PersonName)
>
>School (SchoolID[pk], SchoolName, PersonID[fk])
>
>
>as you can see PersonID is the foreign key in School.
>So how do keep update and delete restricted constraints etc,?
>
>could anyone tell me the SQL code for bot the tables?
>
>duke.
Sir, look up REFERENCES in the documentation. But the documentation
points out that this is for compatibility with other DBMSs, and
doesn't actually do anything. MySQL doesn't enforce integrity
constraints on foreign keys.
Bob Hall
Know thyself? Absurd direction!
Bubbles bear no introspection. -Khushhal Khan Khatak
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
