mysql多表条件更新

bas_student a,bas_householder b SET a.mobile=NULL WHERE a.mobile=b.HouseHolderMobile AND LENGTH(a.Mobile)=11;

 

mysql多表条件更新

标签：条件   blog   and   mysq   重复   手机   多表   weight   household