Stored Procedure tutorial with example

[aadsaca]

Hello everyone!

Please give me good examples of stored procedures in mysql5.

or give me sites with good tutorial about stored procedures.


tnx,
arjel

[mgpsivan]

Hello everyone!

Please give me good examples of stored procedures in mysql5.

or give me sites with good tutorial about stored procedures.


tnx,
arjel

Hi arjel,
This is how we shall use a Stored procedure in MySQL 5.0
Example:

Delimiter $$
DROP PROCEDURE IF EXISTS getAuthors $$
CREATE PROCEDURE getAuthors ()
BEGIN
SELECT 
    AuthorName,
    Address,
    City,
    Phone
FROM Author
END $$
Delimiter ;

The Delimiter should be specified else error will be thrown.Parameter can be passed in the first line of the procedure as
Create Procedure Procedurename(param1 datatype)
The procedure can be executed as
Call procedurename([parameters values])

Regards
Sivan.G

Please enclose any code within the proper code tags. See the Posting Guidelines on how to do that.

MODERATOR

[ronverdonk]

Hello everyone!

Please give me good examples of stored procedures in mysql5.
or give me sites with good tutorial about stored procedures.

tnx,
arjel

If you just had googled, like I did, you would have found numerous articles. Best one is (still) from MySQL development itself HERE with a downloadable document, and ALSO HERE and then DIY Approach to Stored Procedures in MySQL

Ronald

[aadsaca]

Thanks to all!

i'll gonna browse those websites.

tnx again,
arjel

[aadsaca]

to all,

Where should i start?
Do I need to set-up something in mysql5 ?

tnx,
arjel

[aadsaca]

to all,

in the tutorial(pdf file)
it says:

After you've installed the latest version, you should run
either mysql_fix_privilege_tables or mysql_install_db -- or stored procedures won't work for you.

sadly,
i dont know where to run it....
please help me.

tnx,
arjel