E4 Stored Procedure Experimental Objective In Mysq, learn how to define and call the stored procedure. Experimental Requirement Basic Hardware ConfigurationIntel Pentiumlllor above, Greater than 512MB memory 2. Software Requirement: Mysql 3, Hours 2h 4, Experiment Report after Experiment. Definite stored procedure. DELIMITER create procedure update_salary(in empno varchar(30)) in end; DELIMITER Problem1 Please write a procedure which shows the name of the employee and his or her salary according to the inputted employee number CREATE DEFINER=" root.@.% PROCEDURE select price (IN empcode VARCHAR (30)) LANGUAGE SQI NOT DETERMINISTIC CONTAINS SQL SQL SECURITY DEFINER COMMENT BEGIN declare empsalary float; declare empname varchar (30) select ename, sal into empsalary from example.emp where empno- empcode: select empname, empsalary end; END empname