在 MySQL 中创建一个存储过程的语句如下:
DELIMITER $$CREATE PROCEDURE getBook(IN bookName VARCHAR(255))
BEGIN
SELECT * FROM books WHERE name = bookName;
IF NOT FOUND THEN
SELECT '图书不存在' AS message;
END IF;
END$$
DELIMITER ;
在 MySQL 中创建一个存储过程的语句如下:
DELIMITER $$CREATE PROCEDURE getBook(IN bookName VARCHAR(255))
BEGIN
SELECT * FROM books WHERE name = bookName;
IF NOT FOUND THEN
SELECT '图书不存在' AS message;
END IF;
END$$
DELIMITER ;