Delimit

Delimiter //
mysql> create procedure bookreturns (IN p1 int,IN p2 date,IN p3 int,IN p4 int)
    -> begin
    -> update book_issue set status = 'Returned' where issue_id = p1;
    -> insert into bookreturn values(p1,p2,p3,p4);
    -> end //
Query OK, 0 rows affected (0.23 sec)

mysql> call bookreturns(1001,'2024-10-1',0,0);