Entry

Can I execute an UPDATE query with multiple tables in the WHERE condition?

May 10th, 2000 20:02
Nathan Wallace, Evgeniy Zavaliy, Benjamin Pflugmann

UPDATEs which use more than one table, are not possible (yet) with
MySQL. You have to use two statements and either work-around it with a
programming language or with copy&paste by hand.