Untitled

 DELIMITER //
mysql> CREATE PROCEDURE modify2 (     IN s1 INT,     IN s2 VARCHAR(30),     IN s3 INT,     IN s4 INT,     IN s5 INT,     IN s6 DATE,     IN s7
 INT,     IN s8 VARCHAR(20),     IN s9 INT ) BEGIN     IF s9 = 1 THEN          INSERT INTO book VALUES (s1, s2, s3, s4, s5, s6, s7, s8);     ELSEIF s9 = 2 THEN         UPDATE book SET mrp = s4, volume = s7, status = s8 WHERE book_id = s1;     ELSEIF s9 = 3 THEN         DELETE FROM book

 CALL Modify(1, 'Book Title', 1, 250, 5, '2023-10-01', 2, 'Available', 1);