Re: [sqlite] Query to compare two sqlite databases

On 24-09-10 21:06, Rich Shepard wrote: > On Fri, 24 Sep 2010, John Reed wrote: > >> I compare an application every few days which has sqlite as it's client >> database. I look at the content and check whether documents have made it >> into the application after it has been built. I also check

Re: [sqlite] Tricky grouping query

On 01-10-10 22:30, Igor Tandetnik wrote: > Andy Chambers wrote: >> Given the following >> >> create table events ( >> id, >> date, >> status >> ); >> insert into events values ('001','a','N'); >> insert into events values ('001','b','N'); >> insert into events

Re: [sqlite] How to optimize a multi-condition query

On 15-10-10 14:34, Black, Michael (IS) wrote: > I love simple examples like this can help people with understanding > things...so I tried this which I thought would do what Hilmar wants...but > alaswhat concept am I missing? > > SQLite version 3.7.2 > sqlite> create table c(achr char,bchr

Re: [sqlite] Simple SQL question?

On 17-11-10 00:17, Petite Abeille wrote: > select t1.patient_id > fromtable1 t1 > join( > select table1.address, > min( table1.date_of_birth ) as date_of_birth > fromtable1 > group bytable1.address >

Re: [sqlite] Simple SQL question?

On 17-11-10 09:58, Bart Smissaert wrote: > What do you suggest should be the full SQL then? > select t1.patient_id fromtable1 t1 join( select table1.address, min( table1.date_of_birth ) as date_of_birth fromtable1

Re: [sqlite] Simple SQL question?

On 17-11-10 10:00, luuk34 wrote: > On 17-11-10 09:58, Bart Smissaert wrote: >> What do you suggest should be the full SQL then? >> > select t1.patient_id > fromtable1 t1 > join( > select table1.address, >

Re: [sqlite] Key Value pairs in a table

On 17-11-10 10:32, Arigead wrote: > Hi all, > I've started to use an existing Database with C source code. As I'm new > to > all this I can't moan about database design but I'm sure that Key Value pairs > in a Database table suits modern languages like Python down to the ground. It > ain't

Re: [sqlite] [ERROR] Failed compound query with simple expr in ORDER BY

On 26-11-10 12:37, Drake Wilson wrote: > Quoth Waldemar Derr, on 2010-11-26 12:24:27 +0100: >> --Don't working: (Error: 1st ORDER BY term does not match any column in the >> result set.) >> >> SELECT * FROM OrderTest WHERE Price< 200 >> UNION >> SELECT * FROM OrderTest WHERE

Re: [sqlite] [ERROR] Failed compound query with simple expr in ORDER BY

On 26-11-10 13:02, Drake Wilson wrote: > Quoth luuk34<luu...@gmail.com>, on 2010-11-26 12:49:53 +0100: >> The extra column seems to work, >> but i thought this should work too? > I would imagine so, at first glance. > >> But the ORDER is wrong... > How? The

Re: [sqlite] SQLite Documentation

On 04-12-10 14:15, Max Vlasov wrote: > On Sat, Dec 4, 2010 at 11:51 AM, Dagdamor wrote: > >> Hello. >> >> Would you like to have a downloadable version of the SQLite Documentation? >> I've created one in Windows HTML Help (.chm) format. It seems to be useful, >> single-file

Re: [sqlite] SQLite Documentation

On 04-12-10 17:30, Dagdamor wrote: > luuk34<luu...@gmail.com> писал(а) в своём письме Sat, 04 Dec 2010 > 20:24:45 +0600: >> On 04-12-10 14:15, Max Vlasov wrote: >>> Serge, I don't know what's so special about my chm viewer (bundled with >>> Windows 7), but

Re: [sqlite] [Bulk] How to optimize this simple select query ?

On 09-12-10 17:27, Vander Clock Stephane wrote: > no one have an idea how to do such query ?? > > thanks > stéphane > > On 12/8/2010 7:56 PM, Vander Clock Stephane wrote: >> Hello, >> >> on the table : >> >> CREATE TABLE HASH( >> . >> x5_y5>=<#randomnumber73> and >>

Re: [sqlite] Reading a text file and insert to sqlite tables

On 09-12-10 18:13, yazdan asgari wrote: > Hi > I use C Programming Language and I also know that I could use INSERT command. > But my problem is whether any one could show me a simple code which > demonstrate how an INSERT command should be written during reading a text > file. I have

Re: [sqlite] Reading a text file and insert to sqlite tables

On 09-12-10 18:53, yazdan asgari wrote: > > --- On Thu, 12/9/10, luuk34<luu...@gmail.com> wrote: > > From: luuk34<luu...@gmail.com> > Subject: Re: [sqlite] Reading a text file and insert to sqlite tables > To: "General Discussion of SQLite Database"&l

Re: [sqlite] Select

On 10-12-10 11:53, lucavb wrote: > Hello, > i need to to do this: > > i have this table: "userrates", composed by: id, userid, idtitle, rate. > > for example: > (1, 12, 1, 3) > (2, 15, 99, 4) > (3, 22, 10, 1) > (10, 22, 1, 5) > (5, 166, 37, 1) > (4, 244, 10, 2) > (6, 298, 1, 4) > (7, 298, 10, 3)

Re: [sqlite] Select

On 10-12-10 12:03, luuk34 wrote: > > > On 10-12-10 11:53, lucavb wrote: >> Hello, >> i need to to do this: >> >> i have this table: "userrates", composed by: id, userid, idtitle, rate. >> >> for example: >> (1, 12, 1, 3) >> (

Re: [sqlite] Select

On 10-12-10 12:43, Kees Nuyt wrote: > On Fri, 10 Dec 2010 02:53:32 -0800 (PST), lucavb > wrote: > >> Hello, >> i need to to do this: >> >> i have this table: "userrates", composed by: id, userid, idtitle, rate. >> >> for example: >> (1, 12, 1, 3) >> (2, 15, 99, 4) >> (3,

Re: [sqlite] SQLite Documentation v2

On 10-12-10 19:02, Tito Ciuro wrote: > Hello Dagdamor, > > Does it only work for Explorer? No Linux or Mac support? > > -- Tito > *http://tinyurl.com/2vr3dal ^^ chm readers/viewers for linux... * ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] calculate difference of two times and show the result as double value

On 10-01-11 08:42, Sven wrote: > Dear SQLite users, > > I've created a Microsoft Access 2003 database with three complex queries > written in pure SQL language. The function of the database is to > document and calculate the daily work-time. > > Today I want to convert this database to SQLite

Re: [sqlite] max length of integer?

On 10-01-11 13:09, Simon Slavin wrote: > On 10 Jan 2011, at 10:05am, KimTaein wrote: > >> What is the largest number that I can store in integer data type in sqlite? >> I was not able to find it on sqlite website. > You're right. It's not in the obvious place. You can, however, find it here: > >

Re: [sqlite] Order of UNION query results

On 22-01-11 00:53, Josh Gibbs wrote: > Could someone please clarify for me if the the resulting order of a UNION > query will come back with the left data first, then the right data in > the case > that no ordering has been defined for the query. > > My need is to have a parameter stored in a