Re: [sqlite] Backing up data by date

2004-04-23 Thread Christian Smith
in/commit is not necassary. > >Lloyd >- Original Message - >From: "Christian Smith" <[EMAIL PROTECTED]> >To: "Lloyd thomas" <[EMAIL PROTECTED]> >Cc: <[EMAIL PROTECTED]> >Sent: Thursday, April 22, 2004 4:21 PM >Subject: Re: [sqli

Re: [sqlite] Backing up data by date

2004-04-22 Thread Lloyd thomas
as" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Thursday, April 22, 2004 4:21 PM Subject: Re: [sqlite] Backing up data by date > On Wed, 21 Apr 2004, Lloyd thomas wrote: > > >Forgive my ignorance, I have yet to use a transaction and therefore can you >

Re: [sqlite] Backing up data by date

2004-04-22 Thread Christian Smith
ite command line tool. Any decent SQL guide or web page should explain transactions. > >Lloyd >- Original Message - >From: "Christian Smith" <[EMAIL PROTECTED]> >To: "Lloyd thomas" <[EMAIL PROTECTED]> >Cc: <[EMAIL PROTECTED]> >Sen

Re: [sqlite] Backing up data by date

2004-04-21 Thread Lloyd thomas
ay, 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 sa

Re: [sqlite] Backing up data by date

2004-04-21 Thread Christian Smith
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

[sqlite] Backing up data by date

2004-04-20 Thread Lloyd thomas
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.