1mysql> DELIMITER // ;
2mysql> Create PROCEDURE insert_studentinfo(IN p_id int, IN p_name varchar(20),IN p_Address Varchar(20), IN p_subject Varchar(20))
3 -> BEGIN
4 -> insert into student_info(id, name, address, subject) values (p_id, p_name,p_address, p_subject);
5 -> END //
6Query OK, 0 rows affected (0.09 sec)