Re: The MySQL Stored Procedures and Functions is ready ?

2006-05-05 Thread Martijn Tonies
> The MySQL Stored Procedures and Functions is ready to use on production > systems ? > > or support is very ammature ? > > I need to know because is a project desing decision ! > > Tnks !! > > PLEASE I NEED OPINIONS By the time your project is finish

The MySQL Stored Procedures and Functions is ready ?

2006-05-05 Thread Dyego Souza Dantas Leal
The MySQL Stored Procedures and Functions is ready to use on production systems ? or support is very ammature ? I need to know because is a project desing decision ! Tnks !! PLEASE I NEED OPINIONS i'm crazy to use this ? Tnks in advance MySQL , InnoDB and

Re: Stored Procedures and Functions

2005-09-27 Thread Gleb Paharenko
Hello. Have a look here: http://dev.mysql.com/tech-resources/articles/mysql-storedprocedures.html However, it isn't clear for me what originally read data means. Do you store the time of the first access to the data in some table or somewhere else? You might obtain a better answer from

Re: Stored Procedures and Functions

2005-09-26 Thread Peter Brawley
Justin, >I don't have any experience with stored procedures and find the >Documentation in the MYSQL manual a bit sketchy or maybe I am just >miss reading it. Can any one point me to some documentation that will >help with fully understanding Stored Procedures? >What I am trying to migrate

Stored Procedures and Functions

2005-09-26 Thread Blue Wave Software
I don't have any experience with stored procedures and find the Documentation in the MYSQL manual a bit sketchy or maybe I am just miss reading it. Can any one point me to some documentation that will help with fully understanding Stored Procedures? What I am trying to migrate out of my progra

Re: Need help in Stored procedures and functions

2005-04-07 Thread Peter Brawley
ed help in Stored procedures and functions Dinesh, A stored func returns a scalar. To return multiple values, use an sproc declaring the INOUT variables you need, & pick up their values in the calling code after the sproc has executed. Peter Brawley http://www.artfulsoftware.com - Anchan

RE: Need help in Stored procedures and functions

2005-04-07 Thread Anchan, Dinesh
PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, April 07, 2005 4:03 PM To: Anchan, Dinesh Cc: mysql@lists.mysql.com; [EMAIL PROTECTED] Subject: RE: Need help in Stored procedures and functions "Anchan, Dinesh" <[EMAIL PROTECTED]> wrote on 04/07/2005 03:44:07 PM: > Peter,

RE: Need help in Stored procedures and functions

2005-04-07 Thread SGreen
nk you for your help > > Dinesh > > > ____ > > From: Peter Brawley [mailto:[EMAIL PROTECTED] > Sent: Thursday, April 07, 2005 12:24 PM > To: Anchan, Dinesh > Cc: mysql@lists.mysql.com > Subject: Re: Need help in Stored procedures and func

RE: Need help in Stored procedures and functions

2005-04-07 Thread Anchan, Dinesh
From: Peter Brawley [mailto:[EMAIL PROTECTED] Sent: Thursday, April 07, 2005 12:24 PM To: Anchan, Dinesh Cc: mysql@lists.mysql.com Subject: Re: Need help in Stored procedures and functions Dinesh, A stored func returns a scalar. To return multiple values, use an sproc

Re: Need help in Stored procedures and functions

2005-04-07 Thread Peter Brawley
Dinesh, A stored func returns a scalar. To return multiple values, use an sproc declaring the INOUT variables you need, & pick up their values in the calling code after the sproc has executed. Peter Brawley http://www.artfulsoftware.com - Anchan, Dinesh wrote: Hi,   I am

Need help in Stored procedures and functions

2005-04-07 Thread Anchan, Dinesh
Hi,   I am trying to write a function which returns multiple values.  I don't know if this is allowed or not but i am not able to create this function.  I get the following error:   ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL serv