SP problem in PHPMYADMIN

Question

i got this error ,

When i execute this below sp snippet ,

DROP PROCEDURE get_DETAIL_STATE//

CREATE PROCEDURE get_DETAIL_STATE(IN stateName VARCHAR(255)) BEGIN sELECT cFname,cLname FROM med_patient WHERE cState = stateName; END DELIMITER ;

my updated snippet ,

DELIMITER ; CREATE PROCEDURE get_DETAIL_STATE(IN stateName VARCHAR(255)) BEGIN SELECT cFname,cLname FROM med_patient WHERE cState = stateName; END ;

after issue i tried this snippet ,

Answer 1

It doesn't know what // is, so it considers it a syntax error.

I suspect you forgot to change the delimiter from the default ;.

Answer 2

Have you defined delimiter?

delimiter //