On 03/06/16 18:56, Gelin Yan wrote:
>APSW is great, I have used it for years. I want to know whether it
> support pypy. I have switched to pypy for a while.
APSW at its heart is very much a CPython extension and uses that C API
to bind to SQLite. I did port APSW to pypy a few years ago which
You can simulate either a two-pass or one-pass UPDATE SET ... FROM
, WHERE
By doing one or the other of the following (depending on whether you want
one-pass or two-pass).
for a one-pass update:
BEGIN IMMEDIATE;
SELECT .rowid, FROM WHERE
fetch a row
UPDATE SET x=?, ... WHERE rowid=?
At 23:34 04/06/2016, you wrote:
On 4 Jun 2016, at 10:15pm, Jean-Christophe Deschamps
wrote:
> Can't the same update be done more efficiently with a CTE?
The command inside the WITH has to be a SELECT command.
Definitely not as Ryan pointed out, and as the help file clearly states
otherwis
3 matches
Mail list logo
