SP problem in PHPMYADMIN

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 m开发者_如何学编程ed_patient WHERE cState = stateName; END DELIMITER ;

alt text http://img687.imageshack.us/img687/2715/probxc.jpg

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 ,

---

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

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

---

Have you defined delimiter?

delimiter //

---

Try this

screenshot http://fotos.fotoflexer.com/14f84650413ab50bfd76ccf48db783a8.jpg

Please make sure you change the delimiter in the delimiter text box as shown in the above picture.