该存储过程实现通过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为分界符
该存储过程实现通过bookId来返回bookName
DELIMITER &&
CREATE PROCEDURE pro_getBookNameById(IN bookId INT,OUT bName VARCHAR(20))&& DELIMITER
//delimiter为分界符