MySQL - how to create a Stored Procedure
Creating StoredProcs still feels a little like magic at the moment, but it’s incredibly simple really.
Stored Procs (aka “SPs” or “SProcs”) live within the database and allow a number of activities to be chained together. They also represent an abstraction method so you can help de-couple DB and application code.
However, MySQL didn’t have Stored Procs until a year or two ago and because of this they’re not widespread.
The first thing to remember with MySQL Stored Procs is that the mysql engine will get confused if you write the SP and try and apply it using MySQL Query Browser or just using the mysql command line app; it’ll notice semicolons within your SP and try and apply those and it won’t work. Thus you need to change the delimiter before you define the Stored Proc. We do this by making it // instead of ; (a semicolon) using the “delimiter” command, we then swap it back to using semicolons at the end.
Here’s a standard bit of text that you can re-use as a template.
”
delimiter //
DROP PROCEDURE IF EXISTS xxx//
CREATE PROCEDURE xxx (IN param1 VARCHAR(30), OUT param2 VARCHAR(40))
BEGIN
DECLARE localvar VARCHAR(5);
SET localvar = 'helo';
SET param2 = (SELECT MD5(CONCAT(localvar, param1)) );
/* return the data here using a select statement (incase it's not easy for the caller to use the out param) */
SELECT param2 as md5hashedvarchar;
END;
//
delimiter ;
“
December 12th, 2008 at 11:59 am
Very nice site!
cheap viagra
December 12th, 2008 at 11:59 am
Very nice site!
[url=http://training.cvc4.org/pharm1/14225/2.html]cheap cialis[/url]
December 12th, 2008 at 11:59 am
Very nice site!
[LINK http://training.cvc4.org/pharm1/14225/3.html]cheap tramadol[/LINK]
December 12th, 2008 at 11:59 am
Very nice site!
http://training.cvc4.org/pharm1/14225/4.html
December 12th, 2008 at 11:59 am
Very nice site!
December 15th, 2008 at 3:15 am
Very nice site!
cheap viagra
December 15th, 2008 at 3:15 am
Very nice site!
[url=http://training.cvc4.org/pharm1/14227/2.html]cheap cialis[/url]
December 15th, 2008 at 3:15 am
Very nice site!
[LINK http://training.cvc4.org/pharm1/14227/3.html]cheap tramadol[/LINK]
December 15th, 2008 at 3:15 am
Very nice site!
http://training.cvc4.org/pharm1/14227/4.html
December 15th, 2008 at 3:15 am
Very nice site!
December 22nd, 2008 at 4:01 pm
Beautiful site!
cheap viagra
December 22nd, 2008 at 5:26 pm
Great work,webmaster,nice design!
viagra
December 22nd, 2008 at 6:40 pm
If you have to do it, you might as well do it right
buy viagra
December 22nd, 2008 at 7:52 pm
Excellent site. It was pleasant to me.
buy viagra
December 22nd, 2008 at 9:07 pm
I want to say - thank you for this!
cheap viagra
December 22nd, 2008 at 10:17 pm
Perfect work!
viagra
December 22nd, 2008 at 11:20 pm
Nice site! Thank you!
viagra
December 23rd, 2008 at 12:23 am
Excellent site. It was pleasant to me.
viagra
December 23rd, 2008 at 2:28 am
Great work,webmaster,nice design!
cheap viagra
December 23rd, 2008 at 3:35 am
Perfect site, i like it!
cheap viagra
December 23rd, 2008 at 4:45 am
It is the coolest site,keep so!
buy viagra
December 23rd, 2008 at 5:54 am
I want to say - thank you for this!
viagra
December 23rd, 2008 at 6:59 am
It is the coolest site,keep so!
viagra
December 23rd, 2008 at 8:05 am
Great site. Keep doing.
viagra
December 23rd, 2008 at 10:28 am
Beautiful site!
viagra
December 23rd, 2008 at 11:37 am
Beautiful site!
cheap viagra
December 23rd, 2008 at 12:43 pm
Great site. Keep doing.
buy viagra
December 23rd, 2008 at 12:52 pm
Perfect site, i like it!
buy viagra
December 23rd, 2008 at 1:49 pm
Perfect work!
buy viagra
December 23rd, 2008 at 1:56 pm
I bookmarked this guestbook. Thank you for good job!
viagra
December 23rd, 2008 at 2:52 pm
If you have to do it, you might as well do it right
cheap viagra
December 23rd, 2008 at 3:02 pm
Incredible site!
viagra
December 23rd, 2008 at 4:01 pm
If you have to do it, you might as well do it right
viagra
December 23rd, 2008 at 5:11 pm
It is the coolest site,keep so!
viagra
December 23rd, 2008 at 5:17 pm
If you have to do it, you might as well do it right
cheap viagra
December 23rd, 2008 at 6:13 pm
Beautiful site!
buy viagra
December 23rd, 2008 at 6:16 pm
Beautiful site!
buy viagra
December 23rd, 2008 at 7:16 pm
Incredible site!
buy viagra
December 23rd, 2008 at 8:18 pm
Beautiful site!
viagra
December 23rd, 2008 at 9:15 pm
If you have to do it, you might as well do it right
buy viagra
December 23rd, 2008 at 9:58 pm
Great .Now i can say thank you!
buy viagra
December 23rd, 2008 at 11:08 pm
It is the coolest site,keep so!
cheap viagra
December 23rd, 2008 at 11:44 pm
Great site. Keep doing.
buy viagra
December 23rd, 2008 at 11:59 pm
Perfect work!
cheap viagra
December 24th, 2008 at 12:52 am
Great site. Keep doing.
viagra
December 24th, 2008 at 1:28 am
Great site. Good info
cheap viagra
December 24th, 2008 at 1:46 am
Incredible site!
viagra
December 24th, 2008 at 2:18 am
Great site. Keep doing.
cheap viagra
December 24th, 2008 at 2:37 am
I want to say - thank you for this!
buy viagra
December 24th, 2008 at 3:28 am
Great site. Good info
cheap viagra
December 24th, 2008 at 4:24 am
Great .Now i can say thank you!
viagra
December 24th, 2008 at 5:20 am
Great .Now i can say thank you!
cheap viagra
December 24th, 2008 at 6:15 am
Excellent site. It was pleasant to me.
cheap viagra
December 24th, 2008 at 8:05 am
Perfect site, i like it!
cheap viagra
December 24th, 2008 at 9:54 am
Very interesting site. Hope it will always be alive!
cheap viagra
December 24th, 2008 at 10:20 am
Great site. Good info
buy viagra
December 24th, 2008 at 10:50 am
I want to say - thank you for this!
viagra
December 24th, 2008 at 11:16 am
Incredible site!
cheap viagra
December 24th, 2008 at 11:51 am
Very interesting site. Hope it will always be alive!
viagra
December 24th, 2008 at 12:11 pm
Great .Now i can say thank you!
viagra
December 24th, 2008 at 12:46 pm
Nice site! Thank you!
viagra
December 24th, 2008 at 2:33 pm
Perfect work!
viagra
December 24th, 2008 at 3:48 pm
Great work,webmaster,nice design!
buy viagra
December 24th, 2008 at 4:32 pm
Perfect site, i like it!
buy viagra
December 24th, 2008 at 4:39 pm
It is the coolest site,keep so!
cheap viagra
December 24th, 2008 at 6:23 pm
Perfect site, i like it!
viagra
December 24th, 2008 at 7:09 pm
Great site. Good info
viagra
December 24th, 2008 at 8:03 pm
Very interesting site. Hope it will always be alive!
viagra
December 24th, 2008 at 9:39 pm
Perfect site, i like it!
viagra
December 24th, 2008 at 9:43 pm
Very interesting site. Hope it will always be alive!
buy viagra
December 24th, 2008 at 10:29 pm
Excellent site. It was pleasant to me.
viagra
December 25th, 2008 at 12:09 am
I bookmarked this guestbook. Thank you for good job!
cheap viagra
December 25th, 2008 at 4:13 am
Nice site! Thank you!
cheap viagra
December 25th, 2008 at 5:52 am
Incredible site!
cheap viagra
December 25th, 2008 at 9:17 am
Great .Now i can say thank you!
cheap viagra
December 25th, 2008 at 9:26 am
I want to say - thank you for this!
cheap viagra
December 25th, 2008 at 10:13 am
I bookmarked this guestbook. Thank you for good job!
buy viagra
December 25th, 2008 at 1:01 pm
Great site. Keep doing.
cheap viagra
December 25th, 2008 at 3:18 pm
If you have to do it, you might as well do it right
viagra
December 25th, 2008 at 4:07 pm
Excellent site. It was pleasant to me.
cheap viagra
December 25th, 2008 at 5:46 pm
Perfect work!
buy viagra
December 25th, 2008 at 7:43 pm
Great work,webmaster,nice design!
viagra
December 25th, 2008 at 9:20 pm
I bookmarked this guestbook. Thank you for good job!
buy viagra
December 26th, 2008 at 12:29 am
It is the coolest site,keep so!
buy viagra
December 26th, 2008 at 2:50 am
Very interesting site. Hope it will always be alive!
buy viagra
December 26th, 2008 at 6:23 am
I want to say - thank you for this!
buy viagra
December 26th, 2008 at 11:18 am
I bookmarked this guestbook. Thank you for good job!
viagra
December 26th, 2008 at 3:56 pm
Great .Now i can say thank you!
buy viagra
January 6th, 2009 at 12:42 pm
Very nice site!
cheap viagra
January 6th, 2009 at 12:42 pm
Very nice site!
[url=http://training.cvc4.org/pharm1/14250/2.html]cheap cialis[/url]
January 6th, 2009 at 12:42 pm
Very nice site!
[LINK http://training.cvc4.org/pharm1/14250/3.html]cheap tramadol[/LINK]