单表更新 UPDATE table_name SET field1=new-value1, field2=new-value2 WHERE field=value 多表更新 情况一: UPDATE userA as a , userB as b SET a.num = b.num*0.5 WHERE a.id = b.uid AND a.deleted_at is null;