I have an error in my stored procedure using (mysql 5.6). and I am using Workbench 6.3 CE. My code is as below
DELIMITER // (this line shows error)why??
CREATE PROCEDURE Demo(in v_id int)
BEGIN
select name from student where id=v_id;
END//
delimiter;
Your problem is not the line
DELIMITER //
but the line
delimiter;
You've left out a space; it should be
delimiter ;
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With