How do you create MySQL5 stored procedures?

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

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

www.robbyonrails.com

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

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.