topic Re: MySQL is good, except for.... in Operating System - Linux

MySQL is good, except for....

dan dobbs — Thu, 16 Jan 2003 16:35:00 GMT

MySQL is a good database for a lot of general purpose stuff. I have it back-ending my monitoring solution (Nagios) and my intranet server (PHP-Nuke). My only complaint is that it does not do subqueries [i.e. SELECT * FROM orders WHERE (SELECT snum WHERE cnum = 1001)]. That killed most of an afternoon for me until I doublechecked the manuals. :>)

Re: MySQL is good, except for....

Michael Armbrecht — Fri, 17 Jan 2003 09:56:19 GMT

Which is funny, because that is the #1 reason people usually have for not using MySQL...

Re: MySQL is good, except for....

Jerome Henry — Fri, 17 Jan 2003 10:06:45 GMT

Can't you just... bypass the problem ?
I've been using Mysql for eons, along with MS SQL server (which uses subqueries), and when on Mysql, this problem never affected my queries.
Can't you do a sort of SELECT * FROM orders, snum FROM stuff, WHERE orders.sth=stuff=sthelse AND otherarg ?
Jerome

Re: MySQL is good, except for....

dan dobbs — Fri, 17 Jan 2003 15:45:14 GMT

Sorry, folks, this was supposed to be a reply to someone else's question---don't know how it became a new topic. Please disregard.

Re: MySQL is good, except for....

Hans van Zijst — Wed, 05 Mar 2003 12:40:30 GMT

MySQL is quite nice for lots of general stuff indeed. As for subselects, MySQL doesn't support this. Yet. It's planned and it's already implemented in development version 4.1.

Most of the time, however, you can circumvent a subselect by formulating your query in a different way. Hints about this are on the MySQL-site and probably on lots of other places too.

If you really need subselects (and other SQL-stuff like transactions and views), you could take a look at PostgreSQL (http://www.postgresql.org). PostgreSQL is a lot bigger than MySQL however, and for a reason ;)

Kind regards,

Hans