Re: [sqlite] Updating rank field by points in stats table.

Igor Tandetnik wrote: > "Pejayuk" <[EMAIL PROTECTED]> wrote in > message news:[EMAIL PROTECTED] > >> I have a player stats table with a points field. >> I want to update the rank in this using a single query based on the >> points in the row. >> I am not that good at complex sql but I have

Re: [sqlite] Updating rank field by points in stats table.

"Pejayuk" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > I have a player stats table with a points field. > I want to update the rank in this using a single query based on the > points in the row. > I am not that good at complex sql but I have managed to get the > result I want from

[sqlite] Updating rank field by points in stats table.

I have a player stats table with a points field. I want to update the rank in this using a single query based on the points in the row. I am not that good at complex sql but I have managed to get the result I want from the following select query. SELECT points,(SELECT COUNT(*) FROM stats b WHERE

Re: [sqlite] sqlite3_open returns SQLITE_NOMEM

On Thu, Jun 26, 2008 at 1:38 AM, Ryan Clark <[EMAIL PROTECTED]> wrote: > This is a "known" issue. > http://www.sqlite.org/cvstrac/tktview?tn=2508,6 And I had proposed a patch about a month before: http://www.sqlite.org/cvstrac/tktview?tn=2479 Regards, ~Nuno Lucas > > The fix is to include

Re: [sqlite] sqlite DB creation performance

Message: 4 Date: Thu, 26 Jun 2008 12:15:00 -0700 From: "Cory Nelson" <[EMAIL PROTECTED]> Subject: Re: [sqlite] sqlite DB creation performance To: "General Discussion of SQLite Database" Message-ID: <[EMAIL PROTECTED]> Content-Type: text/plain; charset=UTF-8 >On

Re: [sqlite] SQL understanding problem

If all the collum contents are identical why should it matter wich one is modified? Just do a select ... Limit 1 subquery in the update. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of c.panel Sent: Thursday, June 26, 2008 4:57 PM To:

Re: [sqlite] SQL understanding problem

OK! so rowid should be ok ! thank you! -- View this message in context: http://www.nabble.com/SQL-understanding-problem-tp18142381p18144242.html Sent from the SQLite mailing list archive at Nabble.com. ___ sqlite-users mailing list

Re: [sqlite] SQL understanding problem

On Thu, Jun 26, 2008 at 02:09:14PM -0700, c.panel scratched on the wall: > > I'm new to SQL(ite). > I have two records in a table that have the same values in all columns. I > want to replace a column of only one record. (ex: Firstname Lastname: Pierre > Dupont, Pierre Dupont =>become => Pierre

[sqlite] SQL understanding problem

I'm new to SQL(ite). I have two records in a table that have the same values in all columns. I want to replace a column of only one record. (ex: Firstname Lastname: Pierre Dupont, Pierre Dupont =>become => Pierre Dupont, Paul Dupont). How can I make it with SQL command ? How can I make it with C

Re: [sqlite] sqlite DB creation performance

On Thu, Jun 26, 2008 at 11:58:21AM -0700, Brooks, Phil scratched on the wall: > Hi, I am new to the list and to using sqlite - I am looking at > using sqlite for a 2 way lookup table for my application. > I have a home grown file based solution, but was hoping to > find better performance

Re: [sqlite] sqlite DB creation performance

On Thu, Jun 26, 2008 at 11:58 AM, Brooks, Phil <[EMAIL PROTECTED]> wrote: > Hi, I am new to the list and to using sqlite - I am looking at > using sqlite for a 2 way lookup table for my application. > I have a home grown file based solution, but was hoping to > find better performance and more

Re: [sqlite] sqlite DB creation performance

One additional note - my second experiment also used PRAGMA locking_mode=EXCLUSIVE; I managed to drop that from the script somewhere along the line: /* First I tried some pragmas that looked promising */ PRAGMA journal_mode = OFF; PRAGMA legacy_file_format = OFF; PRAGMA page_size=32768;

Re: [sqlite] sqlite DB creation performance

Creation time would be a bit faster if you don't create the index until AFTER importing the data. That way it doesn't have to worry about keeping things in their proper order on every insert. -Andrea -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of

[sqlite] sqlite DB creation performance

Hi, I am new to the list and to using sqlite - I am looking at using sqlite for a 2 way lookup table for my application. I have a home grown file based solution, but was hoping to find better performance and more functionality by putting the lookup tables into sqlite. I am looking for the

Re: [sqlite] What's the difference between 'count' and 'max'?

On Thu, Jun 26, 2008 at 03:55:16PM +0200, Rapha?l KINDT scratched on the wall: > Hello, > > This two requests are differents from both compute time and results! Why? > > SELECT count(*) FROM events;-- very long for big DB > SELECT max(rowid) FROM events; -- very quick "count(*)" counts

Re: [sqlite] bug with NULL in NOT IN

Dan wrote: > Wow (applauds). That was incredible! > Thanks (bows). :-) > So the upshot is that if a set used with "NOT IN" contains a NULL, > the "NOT IN" operation will never evaluate to true. It may evaluate to > false, it may evaluate to NULL. But never true. > > If we have the expression: >

[sqlite] Attempting to merge large databases

I have several databases files that I need to “merge”. Each one has the same schema and about ½ million records. Here is what I’m currently doing (but in code) C:\Development\Main\Common\SQLite>sqlite3 c:\test\a.db3 SQLite version 3.2.7 Enter ".help" for instructions sqlite> attach

[sqlite] SQLite & ODBC or DDE

Dear SQLite Users, I am considering purchasing an application written in SQLite. Can anyone advise me if I can use ODBC or DDE with the database? Many Thanks Liz -- w TheTangoClub.com e [EMAIL PROTECTED] _ t +44 20 7701 9647

Re: [sqlite] bug with NULL in NOT IN

On Thu, Jun 26, 2008 at 04:35:20PM +0700, Dan wrote: > Do we also have a similar problem with the regular 'IN' operator? In > SQLite at the moment: > >SQLite version 3.6.0 >sqlite> select 1 IN (null, 2, 3), 2 IN (null, 2, 3); >0, 1 > > Should the leftmost column of the result row

Re: [sqlite] bug with NULL in NOT IN

On Jun 26, 2008, at 4:49 AM, Dennis Cote wrote: > D. Richard Hipp wrote: >> >> If I understand Peter correctly, he is saying that NULL should mean >> "unknown" in the context of the RHS of a NOT IN operator. SQLite >> does >> not currently operate this way. SQLite currently interprets a >>

Re: [sqlite] Lemon

arjunkumar keerti wrote: >Hi, >I found in wikipedia that Lemon parser is a part of SQLite project but i >couldn't found any sort of information regarding to LEMON. >Can u give me any documentation regarding how to install it and how to work >for some programs on Lemon parser generator or any