Jump to content


Photo

Subquery in mysql versions.


  • Please log in to reply
2 replies to this topic

#1 shan_cool

shan_cool
  • Members
  • PipPipPip
  • Advanced Member
  • 53 posts
  • LocationChennai,India

Posted 23 January 2006 - 11:26 AM

Hi all,
I am using mysql 3.23.. it doesn't support subqueries... does mysql 4 supports it??? can anyone let me know..

rgds,
shan,
chennai..............

#2 phptryhard

phptryhard
  • Members
  • Pip
  • Newbie
  • 9 posts
  • LocationOntario, Canada

Posted 23 January 2006 - 02:26 PM

[!--quoteo(post=339083:date=Jan 23 2006, 06:26 AM:name=shan_cool)--][div class=\'quotetop\']QUOTE(shan_cool @ Jan 23 2006, 06:26 AM) View Post[/div][div class=\'quotemain\'][!--quotec--]
Hi all,
I am using mysql 3.23.. it doesn't support subqueries... does mysql 4 supports it??? can anyone let me know..

rgds,
shan,
chennai..............
[/quote]


I am not sure about mySQL 4 and subqueries but mySQL 5 supports them

[a href=\"http://dev.mysql.com/doc/refman/5.0/en/subqueries.html\" target=\"_blank\"]http://dev.mysql.com/doc/refman/5.0/en/subqueries.html[/a]
PHP 5.1.1
Apache 2.2.0 (WIN32)
mySQL 5.0.18

#3 fenway

fenway
  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

Posted 24 January 2006 - 07:16 PM

Subquery support was added in version 4.1.
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users