# How do you create MySQL5 stored procedures?

**URL:** <https://www.ruby-forum.com/t/how-do-you-create-mysql5-stored-procedures/101546>\
**Category:** Ruby\
**Created:** [August 6, 2006, 12:21am UTC](https://www.ruby-forum.com/t/how-do-you-create-mysql5-stored-procedures/101546 "2006-08-06T00:21:41Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![tesla](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/t/7cd45c/32.png) [@tesla](https://www.ruby-forum.com/u/tesla)\
**Post date:** [August 6, 2006, 12:21am UTC](https://www.ruby-forum.com/t/how-do-you-create-mysql5-stored-procedures/101546/1 "2006-08-06T00:21:41Z")

</div>

I have figured out how to call MySQL5 stored procedures but would like  
to  
know if it is possible to create them using DBI. I have seen example of  
all  
the major databases but nothing on the syntax for MySQL5.

-Tesla

---

<div class="post-metadata">

**Author:** ![tesla](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/t/7cd45c/32.png) [@tesla](https://www.ruby-forum.com/u/tesla)\
**Post date:** [August 6, 2006, 3:43am UTC](https://www.ruby-forum.com/t/how-do-you-create-mysql5-stored-procedures/101546/2 "2006-08-06T03:43:15Z")

</div>

On Aug 5, 2006, at 3:18 PM, tesla wrote:

> I have figured out how to call MySQL5 stored procedures but would  
> like to  
> know if it is possible to create them using DBI. I have seen  
> example of all  
> the major databases but nothing on the syntax for MySQL5.
> 
> -Tesla

Just taking a wild guess… but you’d likely call the same SQL that  
you would run in the mysql shell.

Robby

–  
Robby R.  
Founder & Executive Director

PLANET ARGON, LLC  
Ruby on Rails Development, Consulting & Hosting

> **[Planet Argon](https://www.planetargon.com)**
>
> Planet Argon is a Ruby on Rails development agency specializing in maintenance and support for existing Rails apps. Based in Portland, OR, Planet Argon has been a member of the Rails community since 2004.

[www.robbyonrails.com](http://www.robbyonrails.com)

+1 503 445 2457  
+1 877 55 ARGON [toll free]  
+1 815 642 4068 [fax]

---

<div class="post-metadata">

**Author:** ![tesla](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/t/7cd45c/32.png) [@tesla](https://www.ruby-forum.com/u/tesla)\
**Post date:** [August 6, 2006, 1:37pm UTC](https://www.ruby-forum.com/t/how-do-you-create-mysql5-stored-procedures/101546/3 "2006-08-06T13:37:40Z")

</div>

That’s is what we are doing now. Some languages and database allow you  
to  
create SPs without using the shell. Like PHP and Oracle or SQL Server.  
Even  
though PHP does not do SPs for MySQL without using shell access.

Maybe this is something that will come later on in Ruby if it does not  
exist  
now.