From: tesla Date: 2006-08-06T20:36:30+09:00 Subject: Re: How do you create MySQL5 stored procedures? ------=_Part_36438_22227052.1154864187661 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline 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. On 8/6/06, Robby Russell wrote: > > > 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 Russell > Founder & Executive Director > > PLANET ARGON, LLC > Ruby on Rails Development, Consulting & Hosting > > www.planetargon.com > www.robbyonrails.com > > +1 503 445 2457 > +1 877 55 ARGON [toll free] > +1 815 642 4068 [fax] > > > > ------=_Part_36438_22227052.1154864187661--