List: | General Discussion | « Previous MessageNext Message » | |
From: | Charles Kirby | Date: | March 11 1999 8:32pm |
Subject: | Re: sort of defragmentation? | ||
View as plain text |
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) >
Thread | ||
---|---|---|
• sort of defragmentation? | Mike Otto | 11 Mar |
• Re: sort of defragmentation? | kalle volkov | 11 Mar |
• Re: sort of defragmentation? | Christian Mack | 11 Mar |
• Re: sort of defragmentation? | Charles Kirby | 11 Mar |
• Re: sort of defragmentation? | Sasha Pachev | 11 Mar |
• Re: sort of defragmentation? | Charles Kirby | 11 Mar |
• Re: sort of defragmentation? | Sasha Pachev | 11 Mar |
• Re: sort of defragmentation? | Charles Kirby | 11 Mar |
• Splitting query results among machines? | Brian Bray | 11 Mar |
• RE: Splitting query results among machines? | Brett Error | 11 Mar |
• SIGSEV using Mysql++ | Sander Pilon | 26 Aug |
• Re: sort of defragmentation? | Ed Carp | 11 Mar |
• Re: sort of defragmentation? | Sasha Pachev | 11 Mar |
• Re: sort of defragmentation? | Ed Carp | 11 Mar |
• Re: sort of defragmentation? | Christian Mack | 12 Mar |
• Re: Splitting query results among machines? | Fred Lindberg | 11 Mar |
• Re: sort of defragmentation? | Ed Carp | 12 Mar |
• Re: sort of defragmentation? | Christian Mack | 13 Mar |
• Re: sort of defragmentation? | Ed Carp | 13 Mar |