ssss

CREATE PROCEDURE Modify (
    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 WHERE BOOK_ID = s1;
    END IF;
END //
DELIMITER ;