On 06/07/2017 17:01, Domingo Alvarez Duarte wrote:
I already did this before but it was not accepted.
For myself I did a modification on sqlite3 to allow the use of "AS" on
delete/update statements.
You can see the parser part here
ror
message if they are not the same as the updated table).
--
˙uʍop-ǝpısdn sı ɹoʇıuoɯ ɹnoʎ 'sıɥʇ pɐǝɹ uɐɔ noʎ ɟı
-Original Message-
From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org]
On Behalf Of John McMahon
Sent: Wednesday, 5 July, 2017 21:17
To: SQLite Users
Subjec
On 06/07/2017 16:33, Clemens Ladisch wrote:
John McMahon wrote:
an alias for an "UPDATE" table name is not permitted. Is there a particular
reason for this?
The UPDATE statement affects a single table. While an alias might be
a convenience, it is not necessary (any naming conflicts in
On 06/07/2017 15:03, Keith Medcalf wrote:
Do you know of any implementation of SQL that accepts an AS clause for the
updated table? I don't think any do.
No Keith, I don't. My only exposure to SQL is sqlite.
Some versions have a FROM extension and you CAN specify an alias for the
On 06/07/2017 17:01, Domingo Alvarez Duarte wrote:
I already did this before but it was not accepted.
For myself I did a modification on sqlite3 to allow the use of "AS" on
delete/update statements.
You can see the parser part here
On 06/07/2017 16:33, Clemens Ladisch wrote:
John McMahon wrote:
an alias for an "UPDATE" table name is not permitted. Is there a particular
reason for this?
The UPDATE statement affects a single table. While an alias might be
a convenience, it is not necessary (any naming conflicts in
ror
message if they are not the same as the updated table).
--
˙uʍop-ǝpısdn sı ɹoʇıuoɯ ɹnoʎ 'sıɥʇ pɐǝɹ uɐɔ noʎ ɟı
-Original Message-
From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org]
On Behalf Of John McMahon
Sent: Wednesday, 5 July, 2017 21:17
To: SQLite Users
Subjec
On 06/07/2017 15:03, Keith Medcalf wrote:
Do you know of any implementation of SQL that accepts an AS clause for the
updated table? I don't think any do.
No Keith, I don't. My only exposure to SQL is sqlite.
Some versions have a FROM extension and you CAN specify an alias for the
I already did this before but it was not accepted.
For myself I did a modification on sqlite3 to allow the use of "AS" on
delete/update statements.
You can see the parser part here
https://github.com/mingodad/sqlite/blob/decimal64/src/parse.y .
Cheers !
On 06/07/17 05:16, John McMahon
John McMahon wrote:
> an alias for an "UPDATE" table name is not permitted. Is there a particular
> reason for this?
The UPDATE statement affects a single table. While an alias might be
a convenience, it is not necessary (any naming conflicts in subqueries
can be resolved by using an alias on
ıɥʇ pɐǝɹ uɐɔ noʎ ɟı
>
> > -Original Message-
> > From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org]
> > On Behalf Of John McMahon
> > Sent: Wednesday, 5 July, 2017 21:17
> > To: SQLite Users
> > Subject: [sqlite] syntax error nea
sıɥʇ pɐǝɹ uɐɔ noʎ ɟı
> -Original Message-
> From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org]
> On Behalf Of John McMahon
> Sent: Wednesday, 5 July, 2017 21:17
> To: SQLite Users
> Subject: [sqlite] syntax error near AS
>
> Hi
>
> Wondering if someo
Hi
Wondering if someone else can spot the syntax error in the following
statement. "locns" is an attached database. There are four "AS" terms in
the statement, they all alias tables.
Ok, found it. It seems that an alias for an "UPDATE" table name is not
permitted. Is there a particular
What version are you using? The "IF NOT EXISTS" clause only exists in SQLite
3.3.0 and later.
- Pam
On 4/5/06, Lucky Luke <[EMAIL PROTECTED]> wrote:
>
> Ok, a VERY VERY strange error, which I can't solve.
>
> I use the SQLite.NET wrapper from www.phpguru.org to use it with C#.
>
> I have the
Ok, a VERY VERY strange error, which I can't solve.
I use the SQLite.NET wrapper from www.phpguru.org to use it with C#.
I have the following query:
sql = "CREATE TABLE IF NOT EXISTS bot_users (" +
"username VARCHAR(100)," +
"password VARCHAR(100) " +
15 matches
Mail list logo