Subject: Re: [sqlite] Syntax help with UPDATE in SQLite Database Browser
Maybe you really have to loop "outside" sqlite to align the rows &
values. From the result you got and the UPDATE documentation, I can
guess that the subselect in the assignment is flattened to a scalar.
Unfort
Maybe you really have to loop "outside" sqlite to align the rows &
values. From the result you got and the UPDATE documentation, I can
guess that the subselect in the assignment is flattened to a scalar.
Unfortunately sqlite does not have something like
update tbl1 set col=tbl2.col from tbl2
valid records. Any more hints?
Rob
-Original Message-
From: John Stanton [mailto:[EMAIL PROTECTED]
Sent: Friday, 8 June 2007 2:48 PM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Syntax help with UPDATE in SQLite Database Browser
You don't seem to be positioning on a row
You don't seem to be positioning on a row in the Parameter table with a
WHERE clause.
Ellis Robin (Bundaberg) wrote:
Could I please get some help on the syntax required to perform my UPDATE
based on a selection from multiple tables? I've been through the
archives but can't seem to make much
Could I please get some help on the syntax required to perform my UPDATE
based on a selection from multiple tables? I've been through the
archives but can't seem to make much sense of the examples given.
I have a table containing 'new' paramater values, I need to update the
relevant records in
On Wednesday 06 July 2005 05:12 pm, Ray Mosley wrote:
> I was already expanding my SQl horizons asking this question.
> What would be a reasonable action?
Anything but a seg fault ;)
display the error perhaps?
>
> On 7/6/05, Jay Sprenkle <[EMAIL PROTECTED]> wrote:
> > On 7/6/05, Kiel W. <[EMAIL
On Tue, 2005-07-05 at 08:52 -0500, Ray Mosley wrote:
> AS a DB rookie, I have replaced the .txt files in an Tcl/Tk application with
> a SQLite database, so it still reads very much like file I/O. While in a
> loop I wrote several records to my files, so now I simply do an INSERT.
> I keep
Ray Mosley wrote:
AS a DB rookie, I have replaced the .txt files in an Tcl/Tk application with
a SQLite database, so it still reads very much like file I/O. While in a
loop I wrote several records to my files, so now I simply do an INSERT.
I keep reading that you optimize performance by using
I was already expanding my SQl horizons asking this question.
What would be a reasonable action?
On 7/6/05, Jay Sprenkle <[EMAIL PROTECTED]> wrote:
>
> On 7/6/05, Kiel W. <[EMAIL PROTECTED]> wrote:
> > >set tran_string "BEGIN TRANSACTION\n"
> > >foreach ...
> > >append tran_string "\n"
> >
On 7/6/05, Kiel W. <[EMAIL PROTECTED]> wrote:
> >set tran_string "BEGIN TRANSACTION\n"
> >foreach ...
> >append tran_string "\n"
> >append tran_string "END TRANSACTION\nCOMMIT TRANSACTION"
> >DB eval "$tran_string"
> Ray,
> Someone may pipe in to correct me, but this is my understanding..
>
>set tran_string "BEGIN TRANSACTION\n"
>foreach ...
>append tran_string "\n"
>append tran_string "END TRANSACTION\nCOMMIT TRANSACTION"
>DB eval "$tran_string"
Ray,
Someone may pipe in to correct me, but this is my understanding..
BEGIN TRANSATION, END TRANSACTION and COMMIT TRANSACTION could be
AS a DB rookie, I have replaced the .txt files in an Tcl/Tk application with
a SQLite database, so it still reads very much like file I/O. While in a
loop I wrote several records to my files, so now I simply do an INSERT.
I keep reading that you optimize performance by using transactions, so
12 matches
Mail list logo