RE: UPDATE WITH row

2005-08-08 Thread Edwin Cruz
Pereira [mailto:[EMAIL PROTECTED] Sent: Friday, August 05, 2005 1:42 PM To: MySQL ML Subject: UPDATE WITH row 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

Re: UPDATE WITH row

2005-08-05 Thread Nuno Pereira
[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

Re: UPDATE WITH row

2005-08-05 Thread SGreen
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: >

UPDATE WITH row

2005-08-05 Thread Nuno Pereira
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: UPDATE int_contxtd_details SET params=(SELECT params FROM int_contxtd_detai