Stored Procedures in MySQL 5

Stored Procedures at last in version 5 of MySQL.

Often people from the SQL Server world would downplay MySQL saying that it lacks views and stored procedures which have been present in the MS world and the PostgreSQL world for a long time.

With the latest version of 5.0.18 MySQL has made a promising effort to bring these cool features into its feature set. I had blogged about Views in Mysql 5 here earlier.

Now got some time to write about the Stored Procedures feature in MySQL 5

Why Stored Procedures ?

  • Stored procedures reduce the amount of code in your application be its PHP, ASP, JSP or .NET .
  • Its also brings in a lot of security into your application coz most of the logic and decision making are handed over to the database.
  • It also means that the database delivers in any kind of environment.
  • Reduced Network Traffic

Links

Database Journal Article
I will post a part 2 of this article where i will take you through some examples

Published by

Varun Krish

Varun Krish has been dabbling with computers and websites for almost 2 decades. He has traveled to over 24 countries and hopes to visit every country on earth one day. He is currently the Editor-in-Chief of FoneArena.com You can follow him on @varunkrish

Leave a Reply

Your email address will not be published. Required fields are marked *