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 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 tried this, but the syntax is incorrect: UPDATE int_contxtd_details SET params=(SELECT params FROM int_contxtd_details WHERE id=35) WHERE id!=35; Can anyone help? -- Nuno Pereira -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
