Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

syntax error: 'delimiter ' is not valid input here

Tags:

mysql

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;
like image 671
Arun nagar Avatar asked Jul 20 '26 01:07

Arun nagar


1 Answers

Your problem is not the line

DELIMITER //

but the line

delimiter;

You've left out a space; it should be

delimiter ;
like image 91
Darwin von Corax Avatar answered Jul 22 '26 18:07

Darwin von Corax