Are subqueries supported with mysql 4.0.25??

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
seodevhead
Forum Regular
Posts: 705
Joined: Sat Oct 08, 2005 8:18 pm
Location: Windermere, FL

Are subqueries supported with mysql 4.0.25??

Post by seodevhead »

Does anyone know if subqueries are supported with MySQL 4.0.25? I did some research in the mysql manual but it looks like it has been available since 3.23?? I am trying subqueries and getting wierd errors. Thanks.
User avatar
John Cartwright
Site Admin
Posts: 11470
Joined: Tue Dec 23, 2003 2:10 am
Location: Toronto
Contact:

Post by John Cartwright »

I believe its either 4.0 or 4.1. Pretty sure it's 4.1 though :wink:

Edit | Yup it's 4.1 http://dev.mysql.com/doc/refman/4.1/en/subqueries.html
Starting with MySQL 4.1, all subquery forms and operations that the SQL standard requires are supported, as well as a few features that are MySQL-specific.
User avatar
seodevhead
Forum Regular
Posts: 705
Joined: Sat Oct 08, 2005 8:18 pm
Location: Windermere, FL

Post by seodevhead »

Thanks a bunch for helping me find this out! I really appreciate it. Looks like I need to go to 4.1
Post Reply