This may be better:
delete from table1 where rowid in (
select table1.rowid
from table2
where table1.id = table2.id
and table2.otherid = 1
);
--- Joe Wilson <[EMAIL PROTECTED]> wrote:
> How about:
>
> delete from table1 where id in (
>select table1.id
> from
How about:
delete from table1 where id in (
select table1.id
from table1, table2
where table1.id = table2.id
and table2.otherid = 1
);
or this:
delete from table1 where rowid in (
select table1.rowid
from table1, table2
where table1.id = table2.id
On 11/30/07, Eduardo Morras <[EMAIL PROTECTED]> wrote:
> e) I'm not sure, but using a journaling or softupdate enabled
> filesystem should means you can disable syncronous pragma.
No; SQLite's synchronous code ensures data reaches disk intact and in
proper order at specific times, regardless of
Hi All,
I have the following code:
bool insert(Uccls *_uccls, TCPAcclBucket *tcpAcclBucket){
int nextCol;
memcpy(, tcpAcclBucket, sizeof (TCPAcclBucket));
bindColumns for tcpAcclRec
//Execute statement
On Fri, Nov 30, 2007 at 05:40:43PM -0500, Bob Rossi wrote:
> Hi,
>
> When I download sqlite, and compile on mingw, like this,
> $ cd sqlite-3.5.3
> $ ./configure --disable-shared --enable-static --disable-tcl
> --prefix=$PWD/../install
> $ make
> ok, up until this point, everything works.
I would not bother with make install on MinGW - too much hassle -
just copy out sqlite3.exe, libsqlite3.a and sqlite3.h manually
to wherever you want to put it.
Or just use the sqlite3.[ch] amalgamation and don't use libsqlite3.a
at all.
--- Bob Rossi <[EMAIL PROTECTED]> wrote:
> However, when
Hi,
When I download sqlite, and compile on mingw, like this,
$ cd sqlite-3.5.3
$ ./configure --disable-shared --enable-static --disable-tcl
--prefix=$PWD/../install
$ make
ok, up until this point, everything works.
However, when I type
$ make install
it fails because tclsh isn't
Thank you all for your input.
-Spiros
--
Image Video & Multimedia Systems Lab.
Department of Electrical & Computer Eng.
National Technical University of Athens
http://www.image.ece.ntua.gr
[EMAIL PROTECTED] wrote:
Spiros Ioannou <[EMAIL PROTECTED]> wrote:
John Stanton wrote:
Sqlite does
Are there any plans to support joins on delete? it can get quite long to
do it the manual way when you have a lot of relational data.
DELETE FROM table
INNER JOIN table2
ON table.id = table2.id
WHERE table2.otherid = 1
This works in standard sql, I realise it may be difficult to implement
That's an improvement, using 3.5.3. I have to define __DARWIN__
instead of __MACOS__ now, but at it least compiles without modifying
any sources.
(I wonder why the config stuff does set __DARWIN__)
I still question whether or not I'm getting a thread safe build
though. If I define
At 19:12 20/11/2007, you wrote:
What are the 'biggest bang for the buck' sqlite optimization techniques
to apply to a working system to tune performance?
Q1)) PRAGMA: Does anyone have experience and good results optimizing
sqlite performance using PRAGMA's? If so, which ones, how were they
Sreedhar.a wrote:
Hi,
I have created database using the joins method.
My database caontains 4 tables with the Artist(1),Album(2),Genre(or)
BGM(3),Combination of all these and Track names in one table.
I am having 4 tables as follows.
*
"create table ALBUM(AlbumId integer
On Nov 30, 2007, at 1:32 PM, [EMAIL PROTECTED] wrote:
Peter Johnson <[EMAIL PROTECTED]> wrote:
I'm running into a problem building SQLite 3.5.1 targeting a minimum
of Mac OS X 10.3, but building against the 10.4 (Universal) SDK.
I think this issue has been addressed in 3.5.3. Have
you tried
Peter Johnson <[EMAIL PROTECTED]> wrote:
> I'm running into a problem building SQLite 3.5.1 targeting a minimum
> of Mac OS X 10.3, but building against the 10.4 (Universal) SDK.
I think this issue has been addressed in 3.5.3. Have
you tried using the latest sources?
--
D. Richard Hipp
I'm running into a problem building SQLite 3.5.1 targeting a minimum
of Mac OS X 10.3, but building against the 10.4 (Universal) SDK.
The problem is that the 10.4 SDK does name mangling on the
pthread_join symbol in some cases. Specifically, if the
_XOPEN_SOURCE symbol is defined,
If you do not use TCL compile Sqlite without it. Use option
--without-tcl. Use configure --help to get an idea of compile options.
Sreedhar.a wrote:
Hi,
I am trying to compile the latest version of the sqlite 3.5.3 in vc++.
i got the following error.
Can anyone help me, what i am
regarding:
"Problem fixed by check-in [3993] on 2007-05-14 14:05 GMT."
Argh! I stupidly had downloaded the current version but somehow was
using the old 3.3.12 version when encountering the error.
My apologies to the list.
Zhang <[EMAIL PROTECTED]> wrote:
> Why SQLite 3.5.3 missed DATA_TO_PGHDR macro?
DATA_TO_PGHDR was an internal implementation detail of
the pager for SQLite versions prior to (roughly) 3.5.0.
(I say "roughly" because I forget exactly when we removed
it.) Internal implementation details are
Hi there,
Thanks a lot Richard for your quick reply. I found the source of the error.
gdb was displaying it in sqlite3_step but it was actually two lines before.
Regards,
David
-
Get easy, one-click access to your favorites. Make Yahoo! your
Thanks to all who have contributed to this topic!
Ron Wilson, Senior Engineer, MPR Associates, 518.831.7546
-Original Message-
From: Dennis Cote [mailto:[EMAIL PROTECTED]
Sent: Thursday, November 29, 2007 11:09 PM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] quickstart
On Nov 29,
Why SQLite 3.5.3 missed DATA_TO_PGHDR macro?
..
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
"Joseph Hsu" <[EMAIL PROTECTED]> wrote:
> Sorry, I use SQLite 3.4.2, NOT SQLite 3.5.2.
> The code in pager.c:2417 (SQLite 3.4.2) is
>
> for(pPg=pPager->pAll; pPg; pPg=pPg->pNextAll){
> pPg->needSync = 0;// <= line 2417
> }
> Is there something wrong to pPg ? why ??
>
We have not
"Sreedhar.a" <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I am trying to compile the latest version of the sqlite 3.5.3 in vc++.
> i got the following error.
>
> Can anyone help me, what i am missing to add.
> I just downloaded all the source files and created a project and started
> compiling.
>
>
On Nov 30, 2007 11:58 AM, Sreedhar.a <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I am trying to compile the latest version of the sqlite 3.5.3 in vc++.
> i got the following error.
>
> Can anyone help me, what i am missing to add.
> I just downloaded all the source files and created a project and started
Hi,
I am trying to compile the latest version of the sqlite 3.5.3 in vc++.
i got the following error.
Can anyone help me, what i am missing to add.
I just downloaded all the source files and created a project and started
compiling.
Compiling...
tclsqlite.c
25 matches
Mail list logo