UPDATE 
exp_channel_titles t,
exp_channel_data d,
exp_playa_relationships p,
exp_channel_titles devt,
exp_channel_data devd 
SET
t.author_id = devd.field_id_100
WHERE
t.entry_id = d.entry_id
AND t.entry_id = p.parent_entry_id
AND p.parent_field_id = 62
AND p.child_entry_id = devt.entry_id
AND devt.entry_id = devd.entry_id
AND t.channel_id = 2
AND devd.field_id_100 != '';

update qry

author_id update

MySQL