mysql更新一个表里的字段等于另一个表某字段的值
update gy_user_lawyer as u left join gy_user_lawyer_info as ui on u.ul_id = ui.ul_id set u.ul_tel = ui.uli_remark where u.ul_tel is null;
- 上一篇: 中国互联网有哪些黑色产业链？
- 下一篇: 2017 年 PHP 程序员未来路在何方
update gy_user_lawyer as u left join gy_user_lawyer_info as ui on u.ul_id = ui.ul_id set u.ul_tel = ui.uli_remark where u.ul_tel is null;