该存储过程实现通过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为分界符
//测试如下
CALL pro_getBookNameById(15,@bookname)//@bookname为会话变量,类似于java中的全局变量,传入id为15
SELECT @bookname