mysql定义一个简单的存储过程

该存储过程实现通过bookId来返回bookName

DELIMITER &&

CREATE PROCEDURE pro_getBookNameById(IN bookId INT,OUT bName VARCHAR(20))
BEGIN 
SELECT bookName INTO bName FROM t_book WHERE id=bookId;
END

&& DELIMITER

//delimiter为分界符