On 2008 October 31 (Fri) 10:57:34pm PDT, yoky <[EMAIL PROTECTED]> wrote:
>> Hi all,
>> I create a table like this "create table tbl1 (ID integer primary
>> key, name, addr)" ,
>> then insert a record:
>> "insert into tbl1 values(1, 'aa', 'bb')",
>> select the record:
>> "select * from tbl1 where na
On 2008 October 29 (Wed) 03:26:45pm PDT, James Sheridan <[EMAIL PROTECTED]>
wrote:
> Related addendum:
>
> In reading it appears that MySQL treats "," as a CROSS JOIN and implements it
> effectively as an INNER JOIN.
> a) Is this correct?
Not really, no.
MySQL treats "," as a CROSS JOIN, which
On 2008 September 25 (Thu) 08:40:13am PDT, "Ribeiro, Glauber" <[EMAIL
PROTECTED]> wrote:
> The documentation for sqlite3 on the web site:
> http://www.sqlite.org/sqlite.html
>
> Lists a .bail (on|off) command (stop after hitting an error. Default
> off)
>
> This doesn't seem to be implemented in
On 2008 September 16 (Tue) 07:12:02am PDT, "Jay A. Kreibich" <[EMAIL
PROTECTED]> wrote:
> On Mon, Sep 15, 2008 at 10:57:37PM -0700, Tomas Lee scratched on the wall:
>
>> I want to delete the 1000 members with the lowest scores. Assume that
>> it is extremel
On 2008 September 22 (Mon) 06:25:34am PDT, jason weaver <[EMAIL PROTECTED]>
wrote:
> "jason weaver" <[EMAIL PROTECTED]> wrote:
> news:[EMAIL PROTECTED]
>>> However, due to database locking issues, I need to do a bunch of
>>> inserts in one transaction or batch. Thus, I store them in a simple
>>>
I have this schema:
CREATE TABLE members
(uid INTEGER PRIMARY KEY AUTOINCREMENT,
name TEXT,
score INTEGER);
CREATE INDEX members_score_index ON log (score);
I want to delete the 1000 members with the lowest scores. Assume that
it is extremely unlikely for two members to have identical sc
How can I use the Tcl extentions of SQL 3.6.2 with Tcl 8.3?
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
On 2008 April 13 (Sun) 12:43:22pm PDT, Aladdin Lamp? <[EMAIL PROTECTED]> wrote:
> Thank you Nicolas for your answer. I understand that an int64
> certainly gives me enough precision in the general case.
>
> Now what am I supposed to do if the user decides to add a virtual 4
> decimal digits number
On 2008 April 12 (Sat) 05:44:53pm PDT, Shawn Wilsher <[EMAIL PROTECTED]> wrote:
> When using SQLite 3.5.4.1 (a special branch cut for Mozilla, based
> mostly off of 3.5.4 with some OS/2 fixes), I'm getting SQLITE_LOCKED
> returned unexpectedly. The documentation seems to indicate that I
> should o
On 2008 March 17 (Mon) 07:24:29am PDT, Bharath Booshan L <[EMAIL PROTECTED]>
wrote:
> On 3/14/08 7:17 PM, "P Kishor" <[EMAIL PROTECTED]> wrote:
>
>> I have now twice gotten the following message. What gives?
>>
>>
>> This is the mail system at host sqlite.org.
>>
>> I'm sorry to have to inform
On 2008 March 15 (Sat) 05:21:53pm PDT, Jeff Hamilton <[EMAIL PROTECTED]> wrote:
> What about something like this:
>
> SELECT title FROM tracks
> WHERE singer='Madonna'
>AND (title<:firsttitle OR (title=:firsttitle AND rowid<:firstrowid))
> ORDER BY title DESC, rowid ASC
>
On 2008 January 16 (Wed) 04:57:42am PST, [EMAIL PROTECTED] wrote:
> Tomas Lee <[EMAIL PROTECTED]> wrote:
> > I've got an application that has Berkeley DB embedded in it. I want
> > to replace Berkeley DB with SQLite. (I plan to use the 3.5.4
> > almagamation,
I've got an application that has Berkeley DB embedded in it. I want
to replace Berkeley DB with SQLite. (I plan to use the 3.5.4
almagamation, which is the latest I could find.) The thing is, this
application uses threads. I know threads are evil, but this
application uses them, and there it is
13 matches
Mail list logo