Re: recursive sql statement
Bernhard Schmidt [EMAIL PROTECTED] wrote: sorry for this mysql newbie question, but what means planned for the near future? ist this weeks, months or years away? As to CONNECT BY it means the beginning of the next year. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
recursive sql statement
hi i searched the mysql doc for support of recursive sql statements, but found nothing. i am right that mysql does not support such kind of statements? best regards benny
Re: recursive sql statement
Benny: What do you mean by 'recursive sql statements'? If you are talking about triggers and stored procedures, the answer is no. Gerald Jensen - Original Message - From: Bernhard Schmidt [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, July 09, 2003 2:58 AM Subject: recursive sql statement hi i searched the mysql doc for support of recursive sql statements, but found nothing. i am right that mysql does not support such kind of statements? best regards benny -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: recursive sql statement
Hi Benny, May I guess that you are talking about nested queries or subseects ? If yes than they are supported from Version 4.1. If no, than I have no clue what you are talking about ;-) Best regards Nils Valentin Tokyo/Japan 2003 7 9 20:26Gerald R. Jensen : Benny: What do you mean by 'recursive sql statements'? If you are talking about triggers and stored procedures, the answer is no. Gerald Jensen - Original Message - From: Bernhard Schmidt [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, July 09, 2003 2:58 AM Subject: recursive sql statement hi i searched the mysql doc for support of recursive sql statements, but found nothing. i am right that mysql does not support such kind of statements? best regards benny -- --- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: recursive sql statement
for me a recursive sql statement is when the result of a query can be used for a following query. the statement has start and stop condition. such kind of queries is useful for tree traversal. sql is based on relational algebra that does not allow to write such expressions. but as mentioned by rudy metzger some databases defines extensions to sql, oracle uses connect by. db2 has another apporach using with. best regards benny
Re: recursive sql statement
Hi Benny, Thank you for the explanation, but I believe thats out of my reach to give any advice here ;-) Best regards 2003 7 9 21:30Bernhard Schmidt : for me a recursive sql statement is when the result of a query can be used for a following query. the statement has start and stop condition. such kind of queries is useful for tree traversal. sql is based on relational algebra that does not allow to write such expressions. but as mentioned by rudy metzger some databases defines extensions to sql, oracle uses connect by. db2 has another apporach using with. best regards benny -- --- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: recursive sql statement
Bernhard Schmidt [EMAIL PROTECTED] wrote: for me a recursive sql statement is when the result of a query can be used for a following query. the statement has start and stop condition. such kind of queries is useful for tree traversal. sql is based on relational algebra that does not allow to write such expressions. but as mentioned by rudy metzger some databases defines extensions to sql, oracle uses connect by. db2 has another apporach using with. CONNECT BY currently is not supported, but it's in TODO list: http://www.mysql.com/doc/en/TODO_future.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: recursive sql statement
hi victoria sorry for this mysql newbie question, but what means planned for the near future? ist this weeks, months or years away? best regards benny
RE: recursive sql statement
Everything from month to years. Might even be tomorrow... /rudy -Original Message- From: Bernhard Schmidt [mailto:[EMAIL PROTECTED] Sent: woensdag 9 juli 2003 16:07 To: [EMAIL PROTECTED] Subject: Re: recursive sql statement hi victoria sorry for this mysql newbie question, but what means planned for the near future? ist this weeks, months or years away? best regards benny -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
re: recursive sql statement
See http://www.mysql.com/doc/en/TODO_future.html Oracle-like CONNECT BY PRIOR ... to search tree-like (hierarchical) structures. Whatever their definition of The Near Future is... I'd guess v5 J - Original Message - From: Bernhard Schmidt [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, July 09, 2003 2:58 AM Subject: recursive sql statement hi i searched the mysql doc for support of recursive sql statements, but found nothing. i am right that mysql does not support such kind of statements? best regards benny -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: recursive sql statement
If you are looking for ways to retrieve and store hierarchical data (employees and managers, for instance) I'll also recommend looking at the Nested Set hierarchy. Search news groups for it, and look into Joe Celko's book _SQL For Smarties_, which describes the technique. You can store a complete hierarchical tree in mySQL, get the list of managers for an employee (in descending/ascending order) etc.. It's a powerful structure. I've used it to create powerful structures that operate, with the same SQL, on oracle, mysql, sql server, and others. -Original Message- From: Knepley, Jim [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 09, 2003 11:35 AM To: [EMAIL PROTECTED] Subject: re: recursive sql statement See http://www.mysql.com/doc/en/TODO_future.html Oracle-like CONNECT BY PRIOR ... to search tree-like (hierarchical) structures. Whatever their definition of The Near Future is... I'd guess v5 J - Original Message - From: Bernhard Schmidt [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, July 09, 2003 2:58 AM Subject: recursive sql statement hi i searched the mysql doc for support of recursive sql statements, but found nothing. i am right that mysql does not support such kind of statements? best regards benny -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql? [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]