mySql make procedure

procedure.sql

DELIMITER $$
DROP PROCEDURE IF EXISTS insertRent$$
CREATE PROCEDURE insertRent(libmemberNo INT(11), bookNo INT(11), payTotal INT(30),bookState VARCHAR(5))
BEGIN
INSERT INTO book_rent(
			libmember_no, 
			book_no, 
			brent_start
		) VALUES (
			libmemberNo, 
			bookNo, 
			NOW()
		);
		INSERT INTO pay(
			libmember_no,
			brent_no,
			pay_total
		) values (
			libmemberNo,
			LAST_INSERT_ID(),
			pay_total		
		);
UPDATE book A INNER JOIN book_rent B 
ON A.book_no = B.book_no
SET A.book_stte = bookState;
		
END$$

DELIMITER $$

-- 생성된 프로시저 호출

call insertPay(값,값,값,값);