update table1 a left join table2 b on a.id = b.user_id left join table3 c on a.id = c.user_id
set a.phone_tel = null,
b.id_code = null,
c.identity_no = null,
c.identity_type = null
where a.phone_tel = ‘16718787005‘;
原文：https://www.cnblogs.com/Struts-pring/p/11640849.html