I think this should work:
Update int_contxtd_details a, int.contxtd_details b
Set a.params = b.params
Where B.id=25
And a.id!=25
This will work in a php script where we cannot use more than one sql at the
same time or also will work y a front end manager
-Original Message-
From: Nuno Pe
[EMAIL PROTECTED] wrote:
Nuno Pereira <[EMAIL PROTECTED]> wrote on 08/05/2005 02:41:45 PM:
Following the "SELECT DISTINCT" topic, I have another question.
I tryed to UPDATE all the tables, replacing one column in every tables
with the contents of one specific row. I tried this, but the synta
Nuno Pereira <[EMAIL PROTECTED]> wrote on 08/05/2005 02:41:45 PM:
> Following the "SELECT DISTINCT" topic, I have another question.
>
> I tryed to UPDATE all the tables, replacing one column in every tables
> with the contents of one specific row. I tried this, but the syntax is
> incorrect:
>
