存储过程基本语法的小Demo

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 ;