List:General Discussion« Previous MessageNext Message »
From:B.A.T. (HKG) Svensson Date:May 8 2002 2:06pm
Subject:RE: Undelete??
View as plain text  
> Is it possible to undelete records if you delete all records
> from a MySQL  table accidentally?

IF MySQL support transacation you can do this:

BEGIN TRANSACTION
  DELETE FROM Table_Fubar WHERE 1 = 1

If you want to undo this, execute write:

ROLLBACK TRANSACTION

Other wise execute

COMMIT TRANSACTION
Thread
Undelete??Mike At Spy8 May
  • RE: Undelete??Jay Blanchard8 May
    • Re: Undelete??George Pitcher8 May
  • RE: Undelete??HKG)8 May
RE: Undelete??Walt Weaver8 May
RE: Undelete??Don Vu8 May
RE: Undelete??Max Anderson8 May