This post is labeled under Software Development
This is the continuation of Laboratory Activity 4. I suggest that you do the said lab activity first (if you haven't done so) before proceeding on this activity. You may visit it here.
You can compile multiple SQL statements into one function or program. With stored procedure, you are no longer restricted to run one single SQL statements but allows you work on as many of statements you need to execute for your requirements.
Stored procedure can be created using MySQL Query Browser. Once created, you may detect its existence on the object browser area along with other tables. You may also edit it later on if changes are required as you pull data from your database.
Activity 5 below shows us a guide on how to work on simple stored procedures.
MySQL Stored Procedure Activity 5
Saturday, April 24, 2010
MySQL Stored Procedure
Subscribe to:
Post Comments (Atom)
Posts
I just now wanted to tell you how much I actually appreciate everything you’ve provided to help increase the value of the lives of an individual in this subject matter. Through your current articles, I have gone out of just an inexperienced to a pro in the area. It is truly a honor to your efforts. Thanks
ReplyDeletegreat work on your posting ,you have very interesting post thank you so much for this post
ReplyDeletesummarization of blog was fabulous. gud to see your blogs.:)
ReplyDelete