How to create stored procedure in MySql and how to call stored procedure

 DELIMITER $$

CREATE PROCEDURE new_procedure_procedure_name()

BEGIN

    SELECT * 

    FROM test.new_table t1

    LEFT JOIN test1.table1 t2 ON t1.id = t2.id;

END $$

DELIMITER ;

===============================

CALL new_procedure_procedure_name();