How can i Create STRORED PROCEDURE in MySql,

Posted by Joewilliam under Sql Server on 6/20/2011 | Points: 10 | Views : 1140 | Status : [Member] | Replies : 5
How can i Create STRORED PROCEDURE in MySql, Could you post with example.

William Mary


Responses

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

Up
0
Down
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

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

Up
0
Down
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

Up
0
Down
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

Up
0
Down
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

Up
0
Down
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

Login to post response