List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:May 17 2003 10:09pm
Subject:Re: update from another table
View as plain text  
At 11:28 -0300 5/16/03, Gaston Escobar wrote:
>I'm trying to update table1 from the contents of table2 in mysql 3.23.53.
>I've been reading about this and I've just found solutions with scripts
>(i.e. perl). But I'd need to do it only with one/some sql statements.

You can't do it with a single statement.  Multiple-table updates are
not supported until 4.0.2.

You may be able to do it using SQL only by running some SELECT statements
that generate UPDATE statements.

>Can anybody help me?
>Thanks a lot

Paul DuBois
sql, query
update from another tableGaston Escobar16 May
  • Re: update from another tablePaul DuBois18 May
  • Re: update from another tableCurtis Maurand19 May