How can i Create STRORED PROCEDURE in MySql,

Posted by Joewilliam under Sql Server on 6/20/2011 | Points: 10 | Views : 1174 | Status : [Member] | Replies : 5

How can i Create STRORED PROCEDURE in MySql, Could you post with example.

William Mary

Reply | Reply with Attachment

Posted by: Vforvijay on: 6/20/2011 [Member] Starter | Points: 25

0	hi... For Select all the data from the table you have to write procedure like this.. Create procedure alluser as begin select * from phone end For execute the procedure... exec alluser For More try this links. http://www.sql-server-performance.com/2003/stored-procedures-basics http://vbdotnetaddict.blogspot.com/ Joewilliam, if this helps please login to Mark As Answer. \| Alert Moderator

hi...
For Select all the data from the table you have to write procedure like this..

Create procedure alluser

as

begin

select * from phone

end



For execute the procedure...

exec alluser

Joewilliam, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Vilasgite080 on: 6/20/2011 [Member] Starter | Points: 25

0	hi william here store procedure is used in Application http://www.c-sharpcorner.com/UploadFile/73ba73/7161/ -------------------------- If it Helps you......."MARK AS ANSWER!" Joewilliam, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Ndebata on: 6/20/2011 [Member] Starter | Points: 25

0	Take a look at this http://dev.mysql.com/tech-resources/articles/mysql-storedproc.html Joewilliam, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Naimishforu on: 6/21/2011 [Member] [MVP] Bronze | Points: 25

0	Also have a look at : http://dev.mysql.com/doc/refman/5.0/en/create-procedure.html Thanks, Naimish http://dotnetinterview.zxq.net/ http://naimishpandya.blogspot.in/ Joewilliam, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Lakn2 on: 6/21/2011 [Member] Starter | Points: 25

0	try this http://dev.mysql.com/tech-resources/articles/mysql-storedprocedures.html Thanks&Regards LakshmiNarayana Nalluri. Joewilliam, if this helps please login to Mark As Answer. \| Alert Moderator

Latest Posts