recursive queries

Title: DIY MTB Is there any built in or other support for recursive queries . I suspect not, but wonder what is considered the best approach. With stored procedures being supported in 5.0 is that the way to handle these. Thanks -- Duncan Miller [EMAIL PROTECTED] www.diymtb.com.au

Re: recursive queries

I am looking to do a query on a self join table that returns the parent records. Obviously there are ways to do this, but just wondered if there are any functions in MySQL that make this easier, or specific functions available to stored procedures. I have read the manual and couldn't find

Re: Evaluating text as an expression

- Original Message - *From:* Duncan Miller mailto:[EMAIL PROTECTED] *To:* Rhino mailto:[EMAIL PROTECTED] *Cc:* mysql@lists.mysql.com mailto:mysql@lists.mysql.com *Sent:* Monday, November 07, 2005 1:22 AM *Subject:* Re: Evaluating text as an expression Thanks. I see

Evaluating text as an expression

I am trying to set up a table where the returned value is a result of evaluating an expression that is stored as text (or varchar). The idea is to have a table with a couple of fields that can contain numeric values or expressions eg NameFred Years 3 Commission base 10%

Re: Evaluating text as an expression

comments interspersed below. Rhino - Original Message - From: Duncan Miller [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Sunday, November 06, 2005 8:36 PM Subject: Evaluating text as an expression I am trying to set up a table where the returned value is a result of evaluating