Results 1 to 5 of 5
  1. #1
    Join Date
    Sep 2002
    Location
    Kyiv, Ukraine
    Posts
    77

    Unanswered: sub-queries in MySQL. why not implmented?

    Does anyone have an idea why developers of MySQL didn't implement sub-queries in the database? What are the reasons for this?.. Just curious.
    Yours faithfully,
    Yaroslav Zaremba

  2. #2
    Join Date
    Aug 2001
    Location
    London, UK
    Posts
    31

    Re: sub-queries in MySQL. why not implmented?

    Originally posted by aZa
    Does anyone have an idea why developers of MySQL didn't implement sub-queries in the database? What are the reasons for this?.. Just curious.
    They're not really needed for most things, you can get around the limitations by using LEFT OUTER JOINs.

    That said, they do realise that most people who are familiar with Sql have come to treat the sub-query as the basis for an advanced query... so if you review the TODO list on MySql.com ( http://www.mysql.com/doc/en/TODO_MySQL_4.1.html ) you will see that sub-queries is one of the things that they hope to have in the next version (after 4.0 is out).

    Also in the TODO list for 4.1 are:
    Derived tables: select * from (select name from users where id<10) as users
    CUBE

    And in the TODO in the near future:
    Oracle-like CONNECT BY PRIOR ... to search hierarchy structures.
    Change the format of DATETIME to store fractions of seconds.

    And in the TODO for some time in the future:
    MINUS, INTERSECT, and FULL OUTER JOIN.

    There's lots more that is being worked on, but those things are the ones that crop up a lot and I know that I shall need as soon as they are ready
    My homepage:
    http://www.buro9.com/
    My work:
    http://www.btopenworld.com/
    http://www.officialfootballsites.co.uk/
    http://www.jeepster.co.uk/

  3. #3
    Join Date
    Mar 2001
    Location
    Lexington, KY
    Posts
    606
    4.1 was released today with subquery support.
    http://www.mysql.com/press/release_2003_05.html
    Thanks,

    Matt

  4. #4
    Join Date
    Jan 2003
    Location
    Lima, Perú
    Posts
    11

    Unhappy

    Originally posted by MattR
    4.1 was released today with subquery support.
    http://www.mysql.com/press/release_2003_05.html
    I check the Wb site, but the new version is not available for download
    Jose M.

  5. #5
    Join Date
    Mar 2001
    Location
    Lexington, KY
    Posts
    606
    http://www.mysql.com/downloads/mysql-4.1.html

    Binaries will be available soon.

    You can download the current development source tree from our public BitKeeper repository. Instructions for obtaining and compiling the source is available in our reference manual.
    So you have to jump through hoops to get it. I'd wait until it's stable anyway!
    Thanks,

    Matt

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •