From: Sasha Pachev
Date: March 11 1999 8:50pm
Subject: Re: sort of defragmentation?
List-Archive: http://lists.mysql.com/mysql/36
Message-Id: <36E82C8D.8FFFEF5B@direct1.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Charles Kirby wrote:
> 
> 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

-- 
Sasha Pachev
http://www.sashanet.com/ (home)
http://www.direct1.com/ (work)