mysql存储过程参数应该注意

最新推荐文章于 2024-04-15 10:15:00 发布

wangbintao1992

最新推荐文章于 2024-04-15 10:15:00 发布

阅读量474

点赞数

本文链接：https://blog.csdn.net/wangbintao1992/article/details/17718155

版权

DROP PROCEDURE IF EXISTS avgBookstar;
DELIMITER $$
CREATE PROCEDURE avgBookstar(IN selectBookID CHAR(50),OUT selectBookStar INT)
BEGIN
	SELECT AVG(star) FROM t_comment,t_orderitem,t_book
	WHERE t_orderitem.book_ID = t_book.bookID
	AND t_orderitem.orderItemID = t_comment.orderItem_ID
	AND t_book.bookID = selectBookID
	INTO selectBookStar;
	SELECT selectBookStar;
END $$
DELIMITER ;

CALL avgBookstar('111111',@star);
SELECT @star;


定义 存储过程avgBookstar 参数列表必须和所在表类型匹配

例，CREATE PROCEDURE avgBookstar(IN selectBookID CHAR(50),OUT selectBookStar INT)
selectBookID ChAR  缺少(50) 会查不出