 Mysql Sub-queries, does the hosted version support them? |
|
|
|
|
  |
 Sep 21 2005, 05:28 PM
Post
#1
|
|
|
Newbie [Level 1]  Group: Members Posts: 19 Joined: 8-September 05 From: Atlantic Canada Member No.: 11,632  |
I'm just wondering if the hosted version of MySQL 4.0.xx supports sub-queries? I'm building an application that essentially relies on them. I could work around it, but that means re-working too much.
If you don't know what sub-queries are, please don't bother replying. I may write up a good SQL tutorial someday. |
 |
 
|
|
Sep 21 2005, 05:57 PM
Post
#2
|
|
|
Advanced Member Group: Members Posts: 107 Joined: 9-September 05 From: Houston, TX USA Member No.: 11,651 |
No, subqueries are supported in 4.1.xx and above according to this page from the MySQL Reference Manual.
QUOTE("http://dev.mysql.com/doc/mysql/en/subqueries.html") With MySQL versions prior to 4.1, it was necessary to work around or avoid the use of subqueries. In many cases, subqueries can successfully be rewritten using joins and other methods. See Section 13.2.8.11, “Rewriting Subqueries as Joins for Earlier MySQL Versions”. |
|
|
|
|
Sep 21 2005, 06:46 PM
Post
#3
|
|
|
Newbie [Level 1] Group: Members Posts: 19 Joined: 8-September 05 From: Atlantic Canada Member No.: 11,632 |
QUOTE(sandbox @ Sep 21 2005, 02:57 PM) No, subqueries are supported in 4.1.xx and above according to this page from the MySQL Reference Manual.  thanks sandbox. I thought about looking it up, but am feeling lazy today. I was pretty sure it didn't, figured it might be good to check before I uploaded too much code. guess simple scripts and tutorial site it is for here. 
|
|
|
|
|
Similar Topics
|
Lo-Fi Version | Time is now: 22nd November 2008 - 04:16 PM |