mysql update from select - same table - Stack Overflow

2012年5月1日 - update table as t1 inner join ( select field_id_46,field_id_47 from table where entry_id = 36) as t2 set t1.field_id_60 = t2.field_id_46, t1.field_id_61 ...

stackoverflow.com