MySQL 5 Stored Procedure - Webhost4life Forum

Welcome to Webhost4life Forum Sign in | Join | Faq

MySql

Started by cnbuddy at 11-29-2006 8:10 PM. Topic has 2 replies.

Search

Sort Posts:

11-29-2006, 8:10 PM

cnbuddy is not online. Last active: 11/30/2006 12:07:06 PM cnbuddy

Top 500 Posts
Joined on 11-30-2006
Posts 1

MySQL 5 Stored Procedure

Hi,

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

Thank You

   Report

01-06-2007, 12:24 PM

kingjon is not online. Last active: 1/7/2007 4:23:58 AM kingjon

Top 500 Posts
Joined on 01-07-2007
Posts 1

Re: MySQL 5 Stored Procedure

did you ever get this sorted out - im having the same problem...

   Report

08-11-2007, 1:42 AM

pexpor is not online. Last active: 8/11/2007 4:40:08 PM pexpor

Not Ranked
Joined on 08-11-2007
Posts 1

Re: MySQL 5 Stored Procedure

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

   Report

Webhost4life Fo... » Database Relate... » MySql » MySQL 5 Stored Procedure

webhost4life.com