From: Ed Carp
Date: March 11 1999 8:09pm
Subject: Re: sort of defragmentation?
List-Archive: http://lists.mysql.com/mysql/39
Message-Id: <003601be6bfb$0cc2aa00$74c9a8c0@traveler.airmail.net>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

>> Aha, yes, and speaking of dependencies, are table-to-table dependencies
>> spelled out anywhere (I couldn't find this in the on-line manual)?
>> If, for instance, you deleted a line from a table like "contacts", could
>> this leave any orphan data?
>>
>
>Yes, it could. Since mysql does not suport foreign keys
>and triggers, it is your responsiblity as a programmer
>to ensure that your deletes preserve database integrity


You mean "cascading updates and deletes", don't you?  Triggers and foreign
keys have little to do with whether or not deletes and updates cascade.