Re: [sqlite] Backing up data by date

2004-04-23 Thread Christian Smith
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: [sqlite] Back

Re: [sqlite] Backing up data by date

2004-04-22 Thread Christian Smith
ommand 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]> >Sent: We

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 save the dat

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.