How to create procedure in mysql

 DELIMITER $$

CREATE procedure getAnswerByQuestionId(IN questionID INT)

BEGIN 

SELECT * FROM sh_answers where question_id=questionID;

END$$

DELIMITER ;

call getAnswerByQuestionId(5);

https://www.codegrepper.com/code-examples/sql/sql+cursor+w3schools

https://www.javatpoint.com/mysql-cursor