MySql存储过程小试牛刀

DELIMITER //DROP PROCEDURE IF EXISTS helloworld//CREATE PROCEDURE helloworld()BEGINSELECT 'Hello World' AS F;END //DELIMITER;CALL helloworldDELIMITER //DROP PROCEDURE IF EXISTS testadd//CREATE PROCEDURE testadd(a INT, b INT)BEGINDECLARE c INT;IF a IS NULL THENSET a=0;END IF;IF b IS NULL THEN SET b=0;END IF;SET c=a+b;SELECT c AS SUM;END//DELIMITER;CALL testadd(10, 20)SHOW PROCEDURE STATUSSHOW CREATE PROCEDURE testaddDELIMITER //DROP PROCEDURE IF EXISTS querysong//CREATE PROCEDURE querysong(IN id INT, OUT total INT)BEGINSELECT COUNT(*) FROM songs WHERE songid=idINTO total;ENDCALL querysong(12979290,@total);SELECT @total//DELIMITER;