DELIMITER $$
USE `upaas`$$
DROP PROCEDURE IF EXISTS `testProc`$$
CREATE DEFINER=`wzq`@`localhost` PROCEDURE `testProc`(IN a INT(11),IN b INT(11),IN c VARCHAR(2),OUT r INT(11))
BEGIN
IF(c='+')
THEN SET r = a+b;
END IF;
IF(c='-')
THEN SET r = a-b;
END IF;
IF(c='*')
THEN SET r = a*b;
END IF;
IF(c='/')
THEN SET r = a/b;
END IF;
END$$
DELIMITER ;
USE `upaas`$$
DROP PROCEDURE IF EXISTS `testProc`$$
CREATE DEFINER=`wzq`@`localhost` PROCEDURE `testProc`(IN a INT(11),IN b INT(11),IN c VARCHAR(2),OUT r INT(11))
BEGIN
IF(c='+')
THEN SET r = a+b;
END IF;
IF(c='-')
THEN SET r = a-b;
END IF;
IF(c='*')
THEN SET r = a*b;
END IF;
IF(c='/')
THEN SET r = a/b;
END IF;
END$$
DELIMITER ;