CREATE FUNCTION `updateCompany`(company_new INT(11),company_old INT(11))
RETURNS INT

BEGIN

  set @totalUpdated := (SELECT count(*) FROM asset WHERE  owner_companies_id = company_old);
  set @totalReturn =  @totalReturn + @totalUpdated;
  UPDATE asset SET owner_companies_id = company_new WHERE owner_companies_id = company_old;
  set @totalUpdated := (SELECT count(*) FROM asset WHERE owner_companies_id = company_old);
  set @totalReturn =  @totalReturn + @totalUpdated;
  UPDATE asset SET manufacturer_companies_id = company_new WHERE manufacturer_companies_id = company_old;
  UPDATE asset SET owner_companies_id = company_new WHERE owner_companies_id = company_old;
  set @totalUpdated := (SELECT count(*) FROM asset WHERE distributor_companies_id = company_old);
  set @totalReturn =  @totalReturn + @totalUpdated;
  UPDATE asset SET distributor_companies_id = company_new WHERE distributor_companies_id = company_old;

RETURN @totalReturn;

END;;
DELIMITER ;