create a program for data entries for school management with MySQL and the code must have 500 lines.

CREATE PROCEDURE sp_insert_student
(
  IN p_id int,
  IN p_name varchar(100),
  IN p_gender varchar(1),
)
BEGIN

  INSERT INTO tbl_student(id, name, gender)
  VALUES (p_id, p_name, p_gender);
  
END//