List:General Discussion« Previous MessageNext Message »
From:Thimble Smith Date:October 10 1999 9:56pm
Subject:Re: DELETE SYNTAX
View as plain text  
At 23:25, 19991010, Martin Ramsch wrote:
>b) Copy everything over to a temporary table, except the rows to be
>   deleted, and then replace the old table with the newly created one:

b.i) rename the original table, do your SELECT foo INTO new_table, then
     drop the renamed table.

Tim
Thread
DELETE SYNTAXMichael Farr10 Oct
  • Re: DELETE SYNTAXsinisa10 Oct
  • Re: DELETE SYNTAXMartin Ramsch10 Oct
    • Re: DELETE SYNTAXThimble Smith10 Oct
    • Re: DELETE SYNTAXMichael Farr11 Oct
      • Re: DELETE SYNTAXBenjamin Pflugmann11 Oct
        • Re: DELETE SYNTAXMichael Farr11 Oct
          • Re: DELETE SYNTAXBenjamin Pflugmann11 Oct