List:General Discussion« Previous MessageNext Message »
From:Charles Kirby Date:March 11 1999 7:43pm
Subject:Re: sort of defragmentation?
View as plain text  
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?

Thanks, ck

On Thu, 11 Mar 1999, Christian Mack wrote:
> But try this:
> 
> LOCK TABLE fruits WRITE
> DELETE FROM fruits WHERE ID=2
> UPDATE fruits SET ID=ID-1 WHERE ID>2
> UNLOCK TABLE
> 
> This obviously only works, if you delete only one row.
> And you have to watch out for dependencies on ID in other tables.
> 
> Tschau
> Christian

Thread
sort of defragmentation?Mike Otto11 Mar
  • Re: sort of defragmentation?kalle volkov11 Mar
  • Re: sort of defragmentation?Christian Mack11 Mar
    • Re: sort of defragmentation?Charles Kirby11 Mar
      • Re: sort of defragmentation?Sasha Pachev11 Mar
        • Re: sort of defragmentation?Charles Kirby11 Mar
          • Re: sort of defragmentation?Sasha Pachev11 Mar
            • Re: sort of defragmentation?Charles Kirby11 Mar
              • Splitting query results among machines?Brian Bray11 Mar
                • RE: Splitting query results among machines?Brett Error11 Mar
  • SIGSEV using Mysql++Sander Pilon26 Aug
Re: sort of defragmentation?Ed Carp11 Mar
  • Re: sort of defragmentation?Sasha Pachev11 Mar
Re: sort of defragmentation?Ed Carp11 Mar
  • Re: sort of defragmentation?Christian Mack12 Mar
Re: Splitting query results among machines?Fred Lindberg11 Mar
Re: sort of defragmentation?Ed Carp12 Mar
Re: sort of defragmentation?Christian Mack13 Mar
Re: sort of defragmentation?Ed Carp13 Mar