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