Re: [sqlite] Asking for SQL statement help

Thank you for the quick replies and sorry for not being too clear. I will try to state the problem more clearly, without my own attempts to solve it, as they are incorrect anyway. The simplified schemas again: CREATE TABLE TABLEA ( ID INTEGER PRIMARY KEY, IDB INTEGER, IDC INTEGER, IDD INTEGER

Re: [sqlite] Asking for SQL statement help

On 8 Sep 2009, at 6:31am, Dennis Volodomanov wrote: > Let's say we've got 4 tables: > > CREATE TABLE TABLEA ( ID INTEGER PRIMARY KEY, IDB INTEGER, IDC > INTEGER, IDD INTEGER ); > CREATE TABLE TABLEB ( ID INTEGER PRIMARY KEY, DATA ); > CREATE TABLE TABLEC ( ID INTEGER PRIMARY KEY, DATA ); >

Re: [sqlite] Asking for SQL statement help

On Tue, Sep 8, 2009 at 12:31 AM, Dennis Volodomanov wrote: > Hello all, > > A small SQL problem, no doubt, for experts here. > > Let's say we've got 4 tables: > > CREATE TABLE TABLEA ( ID INTEGER PRIMARY KEY, IDB INTEGER, IDC INTEGER, IDD > INTEGER ); > CREATE TABLE TABLEB (

Re: [sqlite] Asking for SQL statement help

Dennis Volodomanov wrote: > SELECT * FROM TABLEB WHERE ID IN ( SELECT IDB AS ID FROM TABLEA LEFT JOIN > TABLEB ON IDB=1 ) First of all, "IDB=1" isn't a join condition; it doesn't compare a column from TABLEA with a column from TABLEB. Did you mean to say "WHERE" rather than "ON"? In which

[sqlite] Asking for SQL statement help

Hello all, A small SQL problem, no doubt, for experts here. Let's say we've got 4 tables: CREATE TABLE TABLEA ( ID INTEGER PRIMARY KEY, IDB INTEGER, IDC INTEGER, IDD INTEGER ); CREATE TABLE TABLEB ( ID INTEGER PRIMARY KEY, DATA ); CREATE TABLE TABLEC ( ID INTEGER PRIMARY KEY, DATA ); CREATE

Re: [sqlite] Importing data into SQLite

Sounds good. Let us know how things go. P.S. one thing to try may be to use dos2unix to convert any text files created in the Windows/DOS world to unix-format text files. Regards, - Robert On Mon, Sep 7, 2009 at 7:22 PM, Kavita Raghunathan wrote: > The

Re: [sqlite] Importing data into SQLite

On 8 Sep 2009, at 1:22am, Kavita Raghunathan wrote: > I'm using the latest version downloaded last week: amalgamate 3-6-17. > > Robert, > The difference between what you did and what I did was perhaps that > I had excel make the .csv file, and maybe the excel version had > something > to do

Re: [sqlite] Importing data into SQLite

Dan, I'm using the latest version downloaded last week: amalgamate 3-6-17. Robert, The difference between what you did and what I did was perhaps that I had excel make the .csv file, and maybe the excel version had something to do with it ? I'll retry with the exact same steps, and let you know

Re: [sqlite] Booleans in SQLite

On Mon, 7 Sep 2009, Jim Showalter wrote: > Oracle doesn't have a native boolean type. You have to use INTEGER and > interpret it. > > MySQL doesn't have a boolean type (it's just a synonym for TINYINT). > > SQL Server doesn't have a boolean type. You have to use BIT and > interpret it.

Re: [sqlite] Booleans in SQLite

Oracle doesn't have a native boolean type. You have to use INTEGER and interpret it. MySQL doesn't have a boolean type (it's just a synonym for TINYINT). SQL Server doesn't have a boolean type. You have to use BIT and interpret it. - Original Message - From: "Mark Hamburg"

Re: [sqlite] Booleans in SQLite

The real argument for adding boolean support is not about space but about compatibility with dynamic languages with a boolean type that are exploiting SQLite's dynamic typing of values. Without a boolean type in SQLite, a glue layer has to guess whether a 0 means zero or false or a "NO"

Re: [sqlite] Sqlite uses a lot of memory during a delete operation

On Sun, Sep 6, 2009 at 5:23 PM, Benjamin Rutt wrote: > I noticed sqlite is using a lot of memory (up to 300MB before it hits a data > segment size ulimit and fails) during a delete operation.  This is > reproducable using the 'sqlite3' executable distributed with sqlite.  My >

Re: [sqlite] Sqlite uses a lot of memory during a delete operation

On 7 Sep 2009, at 4:01pm, Benjamin Rutt wrote: > Good idea. Tried that, though, and it didn't help - the process > still grew > and grew in memory. Just in case, change the name of your column 'end' to something that isn't a keyword. Simon. ___

Re: [sqlite] Importing data into SQLite

On Sun, Sep 6, 2009 at 9:32 PM, Kavita Raghunathan wrote: > Timothy and all, > When I try to import a .csv, I get a segmentation fault: > 1) First I set .seperator to , > 2) Then I type .import > 3) I see "Segmentation fault" > > Any ideas ? Here's an example of

Re: [sqlite] Importing data into SQLite

On Sep 7, 2009, at 9:32 AM, Kavita Raghunathan wrote: > Timothy and all, > When I try to import a .csv, I get a segmentation fault: > 1) First I set .seperator to , > 2) Then I type .import > 3) I see "Segmentation fault" Which version of SQLite is this happening with?

Re: [sqlite] Attached database

-Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Filipe Madureira Is there a way to get a list of attached databases? Either by SQL or by function call? == Greetings, Filipe, PRAGMA

[sqlite] Attached database

Hi, Is there a way to get a list of attached databases? Either by SQL or by function call? I want to attach several databases, at several points in time. It can happen that I attempt to attach the same database several times, but I want to prevent different attaches to the same database if it

Re: [sqlite] Sqlite uses a lot of memory during a delete operation

> > You're doing this on 68 million rows. While it probably shouldn't > give an error in this way, I can imagine various things that might > cause it. > > To help with debugging, and also as a suggested fix until the problem > can be investigated, could you pre-calculate your 'strftime' value, >