RE: Multi-table updates in MySQL

to:[EMAIL PROTECTED]] > Sent: woensdag 18 september 2002 7:36 > To: [EMAIL PROTECTED] > Subject: Multi-table updates in MySQL > > > I'm using MySQL v3.23.52. > > I want to update a column in one table to be based on a calculated expression > from a column i

Multi-table updates in MySQL

I'm using MySQL v3.23.52. I want to update a column in one table to be based on a calculated expression from a column in another table. Specifically I want something like this: mysql> update a set a.f1=b.f1 where a.f2=b.f2; mysql> update a, b set a.f1=b.f1 where a.f2=b.f2; The first says tabl