Thank you all for your suggestions. I've created a set of manual steps to
create the 1000 table delete query that only took me 10 minutes to
accomplish. A whole lot simpler than trying to figure out how to automate
this entire 1000 table process in SQLite.
-Don
If you are trying to purge a huge database and it is not live, another
possibility is to attach a new blank database and SELECT into it. This way
you don't have to waste time with VACUUM.
On Mon, Sep 24, 2012 at 10:04 AM, Clemens Ladisch wrote:
> Don Goyette wrote:
> > > With
Don Goyette wrote:
> > With 60*60*24 seconds per day, the number of days since the Unix epoch is:
> > sqlite> select strftime('%s', '2012-05-22') / (60*60*24);
> > 15482
>
> The timestamp in the tables I'm reading is not in the format of
> '2012-05-22'.
Sorry, my explanations were not clear
On 9/24/2012 9:25 AM, Don Goyette wrote:
So, I still need to know how to convert the Excel format timestamp (Days
since 1900-01-01) into a Unix Epoch format timestamp (Seconds since
1970-01-01).
I agree with Bart's reply, but to convert epochs, subtract the Excel
format timestamp of
-Original Message-
> From: sqlite-users-boun...@sqlite.org
> [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Clemens Ladisch
> Sent: Sunday, September 23, 2012 6:09 AM
> To: General Discussion of SQLite Database
> Subject: Re: [sqlite] DELETE Query Assistance Please
Don
-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Clemens Ladisch
Sent: Sunday, September 23, 2012 6:09 AM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] DELETE Query Assistance Please
Don Goyette wrote:
&g
Don Goyette wrote:
> The first problem I'm running into is that the timestamp in these tables is
> NOT a standard Unix timestamp. Rather, it's an Excel timestamp, which is
> the number of Days since Jan 1, 1900. An example is '41051.395834' (May
> 22, 2012), but the DELETE query will only
Problem 1 seems simple:
delete from TableX where timestamp < 41115
I think the table name may need to be produced by code.
RBS
On Sun, Sep 23, 2012 at 12:06 PM, Don Goyette wrote:
> Hello Everyone,
>
>
>
> I'm using what has become a huge (3.5 GB) SQLite3 database that
Hello Everyone,
I'm using what has become a huge (3.5 GB) SQLite3 database that was created
by an investment (stocks) tracking program I use. The program does not have
a database purge function to delete old data, and it's no longer supported.
So I'm trying to do this manually with SQL, via a
9 matches
Mail list logo