Hi All, Can anyone please explain to me the usage of foreign keys?
As I understand it, foreign keys are used to relate one table to another. But, mysql (new version can?) cannot ensure that what's inputted is an actual key in that other table. What's the need for foreign keys then? If My insert statements are formatted properly enough that I put in all the values as needed into the table, myself ensuring that what I've inputted is actually already there in the other table. Cheers, Mun Heng, Ow H/M Engineering Western Digital M'sia DID : 03-7870 5168 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]