Hi!
SQL Maestro Group announces the release of SQLite Maestro 11.3, a complete
Windows GUI solution for SQLite database management. The new version is
immediately available at
http://www.sqlmaestro.com/products/sqlite/maestro/
New features
=
1. SQLite Maestro has been
Email forwarded to the sqlite-users mailing list.
I use gcc and gdb and plain old text editor. I am not able to recommend an
IDE since I don't use one.
On Mon, Mar 14, 2011 at 11:16 AM, Thiago Gregolon
thiagogrego...@gmail.comwrote:
Good morning,
My name is Thiago from UDESC - Universidade
Try CodeBlocks
Cross-platform and works with gcc or MSVC or pretty much whatever.
I put in gcc 64-bit for it.
http://www.codeblocks.org/
Michael D. Black
Senior Scientist
NG Information Systems
Advanced Analytics Directorate
From:
Hey guys.
I have a table with an autoincrement primary ID, and as part of a select
I would like to only take the 5000 largest/most recent ids. Is there
a quick way of doing this without having to get the max first?
Thanks,
Ian
___
sqlite-users
select id from table order by id desc limit 5000
Adam
On Mon, Mar 14, 2011 at 1:52 PM, Ian Hardingham i...@omroth.com wrote:
Hey guys.
I have a table with an autoincrement primary ID, and as part of a select
I would like to only take the 5000 largest/most recent ids. Is there
a quick way
Ah, sorry about this - my query is this one:
SELECT * FROM multiturnTable WHERE rowid in (SELECT rowid FROM
multiturnTable WHERE player1 ='?' UNION ALL SELECT rowid FROM
multiturnTable WHERE player2 = '?') AND (complete=0 OR p1SubmitScore=0
OR p2SubmitScore=0)
And I only want to consider the
Assuming that higher rowids really are later rowids, wouldn't adding ORDER BY
rowid DESC and LIMIT 5000 do the job?
Will
On 3/14/11 10:58 AM, Ian Hardingham i...@omroth.com wrote:
Ah, sorry about this - my query is this one:
SELECT * FROM multiturnTable WHERE rowid in (SELECT rowid FROM
Are you wanting the last 5000 from player 1 and last 5000 from player 2?
You can even limit and order the sub selects.
Otherwise, I don't see the purpose of a union when OR would do.
SELECT * FROM multiturnTable WHERE rowid in (SELECT rowid FROM
multiturnTable WHERE player1 ='?' order by
Try this one:
select * from (select * from multiturnTable order by rowid desc limit 5000)
where (player1 = ? or player2 = ?)
and (complete=0 or p1SubmitScore=0 or p2SubmitScore=0)
Pavel
On Mon, Mar 14, 2011 at 1:58 PM, Ian Hardingham i...@omroth.com wrote:
Ah, sorry about this - my query is
In the routine winMutexTry at line 284
-printf(enter mutex %p (%d) with nRef=%d\n, p, p-trace, p-nRef);
+printf(try mutex %p (%d) with nRef=%d\n, p, p-trace, p-nRef);
--
View this message in context:
I updated the debug statement here:
http://www.sqlite.org/src/info/def98fd23e
Thanks for the report.
-Shane
On Mon, Mar 14, 2011 at 7:54 PM, Noah Hart n...@lipmantpa.com wrote:
In the routine winMutexTry at line 284
- printf(enter mutex %p (%d) with nRef=%d\n, p, p-trace, p-nRef);
+
11 matches
Mail list logo