MySQL 5 Stored Procedure

MySql

MySQL 5 Stored Procedure

---

cnbuddy 11-29-2006, 8:10 PM
Hi,

Anyone knows how to create a stored procedure in MySQL 5 using phpMyAdmin from the Control Panel?

Thank You

Re: MySQL 5 Stored Procedure

---

kingjon 01-06-2007, 12:24 PM
did you ever get this sorted out - im having the same problem...

Re: MySQL 5 Stored Procedure

---

pexpor 08-11-2007, 1:42 AM
you can use mysql query to create it
example here

CREATE PROCEDURE `getTopic`(
in p__id varchar(2)
)
BEGIN
     select * from table where id = p_id;
END