Forgive my ignorance, I have yet to use a transaction and therefore can you give me an example.
Lloyd ----- Original Message ----- From: "Christian Smith" <[EMAIL PROTECTED]> To: "Lloyd thomas" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Wednesday, April 21, 2004 3:27 PM Subject: Re: [sqlite] Backing up data by date > On Tue, 20 Apr 2004, Lloyd thomas wrote: > > >Which is the best way to backup rows which meet a certain date criteria? > >ie WHERE data is <= '2003-11-20'. > >Would I need to select and save the data to a temporary table and then DUMP the temp table. > > > > Just begin a transaction to get a snapshot of the database, then dump the > data within the transaction. No temporary table needed. Will lock the > database, but it is the only way to ensure a consistent view unless you > are saving data from a single table or view, in which case you won't need > the transaction. > > Christian > > -- > /"\ > \ / ASCII RIBBON CAMPAIGN - AGAINST HTML MAIL > X - AGAINST MS ATTACHMENTS > / \ > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]