MySql-使用来自同一表的选择语句更新表

update table as t1inner join (select field_id_46,field_id_47 from table where entry_id = 36) as t2set t1.field_id_60 = t2.field_id_46,    t1.field_id_61 = t2.field_id_47where t1.entry_id = 45

或者，简单地

update table as t1,(select field_id_46,field_id_47 from table where entry_id = 36) as t2set t1.field_id_60 = t2.field_id_46,    t1.field_id_61 = t2.field_id_47where t1.entry_id = 45