Re: [sqlite] DELETE Query Assistance Please

2012-09-27 Thread Don Goyette
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

Re: [sqlite] DELETE Query Assistance Please

2012-09-24 Thread E. Timothy Uy
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

Re: [sqlite] DELETE Query Assistance Please

2012-09-24 Thread Clemens Ladisch
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

Re: [sqlite] DELETE Query Assistance Please

2012-09-24 Thread Gerry Snyder
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

Re: [sqlite] DELETE Query Assistance Please

2012-09-24 Thread Bart Smissaert
-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

Re: [sqlite] DELETE Query Assistance Please

2012-09-24 Thread Don Goyette
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

Re: [sqlite] DELETE Query Assistance Please

2012-09-23 Thread Clemens Ladisch
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

Re: [sqlite] DELETE Query Assistance Please

2012-09-23 Thread Bart Smissaert
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

[sqlite] DELETE Query Assistance Please

2012-09-23 Thread Don Goyette
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