How to print out a variable’s value/message from a MySQL stored procedure?

You can use a simple select inside the stored procedure.

Example:

DELIMITER //

DROP PROCEDURE IF EXISTS printTest//

CREATE PROCEDURE printTest(myVar int)

BEGIN

IF myVar <> 0 THEN
SELECT myVar;
ELSE
SELECT 'Got 0';
END IF;

END//


DELIMITER ;