Error when creating PROCEDURE on mysql?

A) You need to DECLARE any variables on the first lines of the procedure, including their datatype: DECLARE bg_mere INT b) To fetch a value from the database into a variable, you use SELECT ... INTO syntax: SELECT categ_bg INTO bg_mere FROM categ_basic WHERE categ_basic. Categ_id = id_mere c) You have an END IF without the corresponding IF d) The closing END needs a semicolon, only then do you need a delimiter to finish the entire statement, and finally you should reset the delimiter back to normal: BEGIN; // body of the stored procedure goes here END; $$ DELIMITER.

A) You need to DECLARE any variables on the first lines of the procedure, including their datatype: DECLARE bg_mere INT; b) To fetch a value from the database into a variable, you use SELECT ... INTO syntax: SELECT categ_bg INTO bg_mere FROM categ_basic WHERE categ_basic. Categ_id = id_mere; c) You have an END IF without the corresponding IF. D) The closing END needs a semicolon, only then do you need a delimiter to finish the entire statement, and finally you should reset the delimiter back to normal: BEGIN; // body of the stored procedure goes here END; $$ DELIMITER.

Your parameters are missing the keyword IN such as: ...(IN id_mere INT, IN lib_categ ...). Also, you need to configure your OUT variable for @bg_mere in the initial parameter list such as (IN xxx, ..., OUT bg_mere VARCHAR/INT/WHATEVER).

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.