Re: sort of defragmentation?

[Charles Kirby]

Ah, that's what I wanted to hear.  But surely, if Mysql doesn't support
foreign keys and triggers, what orphans could possibly result from
deleting a line in the existing mysql?  Other than anything you knowingly
set up yourself to specifically have a relationship from one table to
another, is any relationship built-in with the keystone database?

Thanks, ck

On Thu, 11 Mar 1999, Sasha Pachev wrote:

> 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)
>