DELIMITER $$

USE `hairsalon`$$

DROP PROCEDURE IF EXISTS `servicelink_ins`$$

CREATE DEFINER=`root`@`localhost` PROCEDURE `servicelink_ins`(IN idw INT(11), IN ids INT(11), IN spay DECIMAL(10,2))
    COMMENT 'При добавлении изменить сумму работы на стоимость услуги'
BEGIN
	INSERT IGNORE INTO `hairsalon`.`itemlink` (id_w, id_srv) VALUES (idw, ids);
	UPDATE `hairsalon`.`work` SET `suma` = `suma` + spay WHERE id_w = idw;
    END$$

DELIMITER ;

CALL servicelink_ins(2,3,"125");

	INSERT IGNORE INTO `hairsalon`.`servicelink` (`id_w`, `id_srv`) VALUES (idw, ids);