MySql存储过程小试牛刀

最新推荐文章于 2024-10-31 23:41:03 发布

badboy_blue

最新推荐文章于 2024-10-31 23:41:03 发布

阅读量401

点赞数

分类专栏：数据库文章标签： mysql 存储 null c

本文链接：https://blog.csdn.net/badboy_blue/article/details/6913733

版权

数据库专栏收录该内容

4 篇文章 0 订阅

订阅专栏

DELIMITER //
DROP PROCEDURE IF EXISTS helloworld//
CREATE PROCEDURE helloworld()
BEGIN
SELECT 'Hello World' AS F;
END 
//
DELIMITER;

CALL helloworld


DELIMITER //
DROP PROCEDURE IF EXISTS testadd//
CREATE PROCEDURE testadd(a INT, b INT)
BEGIN
DECLARE c INT;
IF a IS NULL THEN
SET 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 STATUS
SHOW CREATE PROCEDURE testadd

DELIMITER //
DROP PROCEDURE IF EXISTS querysong//
CREATE PROCEDURE querysong(IN id INT, OUT total INT)
BEGIN
SELECT COUNT(*) FROM songs WHERE songid=id
INTO total;
END
CALL querysong(12979290,@total);
SELECT @total
//
DELIMITER;