in the MySQL manual.
John Bonnett
-Original Message-
From: Davy Obdam [mailto:[EMAIL PROTECTED]
Sent: Friday, 30 May 2003 6:57 PM
To: MySQL; MySQL-WIN
Subject: Update query with substring
Hello people,
I am trying to run this query:
UPDATE table1, table2 SET table1.periode = table.per
At 11:26 +0200 5/30/03, Davy Obdam wrote:
Hello people,
I am trying to run this query:
UPDATE table1, table2 SET table1.periode = table.periode WHERE
table1.id = 3 AND SUBSTRING_INDEX( table1.name, '.', - 1 ) =
table2.name
But i keep getting the same error message
You have an error in your SQ
Davy Obdam <[EMAIL PROTECTED]> wrote:
> I am trying to run this query:
>
> UPDATE table1, table2 SET table1.periode = table.periode WHERE table1.id
> = 3 AND SUBSTRING_INDEX( table1.name, '.', - 1 ) = table2.name
>
> But i keep getting the same error message
>
> You have an error in your SQL sy
Hello people,
I am trying to run this query:
UPDATE table1, table2 SET table1.periode = table.periode WHERE table1.id
= 3 AND SUBSTRING_INDEX( table1.name, '.', - 1 ) = table2.name
But i keep getting the same error message
You have an error in your SQL syntax near '
table2 SET table1.periode =