Procedures are created using the CREATE PROCEDURE statement. You must have RESOURCE authority to create a procedure.
CREATE PROCEDURE new_dept(IN id INT, IN name CHAR(35), IN head_id INT) BEGIN INSERT INTO GROUPO.departments(DepartmentID, DepartmentName, DepartmentHeadID) values (id, name, head_id); END