MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.

I'm not curious

IT Career Development Platform

SKIP>>

We built MyTechLogy for you

Help us to help you.

Share your expectations and experience to improve it.

Please enter your feedback.

Click here to continue..

Thank you for your Feedback

Your feedback would help us in sending you the most relevant job opportunities

Advantage of Stored Procedures?

Published on 23 February 13

Csksaravana Follow

Stored Procedures are precompiled one.
it is the group of sql statements.
stored procedure like a application programming.
stored procedure is a fast one because it is already
precompiled.
stored procedure is the one is easy to maintain.

Simple store procedure . It's help to get familiar with syntax.

DELIMITER //
CREATE PROCEDURE procedure_name()
BEGIN
SELECT * FROM table_name;
END //
DELIMITER ;

This blog is listed under Open Source and Data & Information Management Community

Share this Post:

Was the blog helpful?

MySQL

Post a Comment

Please notify me the replies via email.

Important:

We hope the conversations that take place on MyTechLogy.com will be constructive and thought-provoking.
To ensure the quality of the discussion, our moderators may review/edit the comments for clarity and relevance.
Comments that are promotional, mean-spirited, or off-topic may be deleted per the moderators' judgment.