 |
 |
This is true, although I believe you may have some backward compatibility issues with other existing PHP/MySQL programs. This is not confirmed, but I found problems with this on Windows (at least) at home. Still, quite an achievement for MySQL. Also, if you just need a simple SQL db for small jobs, check out SQLite (www.sqlite.org). It's fairly SQL 92 compliant; supports transactions, subqueries, left outer joins; stored all in one file; the db and sql monitor can easily fit on a removable drive... I suppose there's more. -Ross. Hickey,Thom wrote: >I believe that MySQL 4.1 supports nested queries and is now out of beta. > >--Th > > >-----Original Message----- >From: Code for Libraries [mailto:[log in to unmask]] On Behalf Of >Andrew Nagy >Sent: Monday, November 29, 2004 5:20 PM >To: [log in to unmask] >Subject: Re: [CODE4LIB] SQL question > >Andrew Darby wrote: > > > >>Is there a way, in the SQL, to generate my "mama bear" set: i.e., with >>the subjects grouped together like so: >> >>Smith, Joe | English, History, Italian | 425-5000 | [log in to unmask] >>Turner, Ted | Math, Politics, Zoology | 425-5111 | [log in to unmask] >> >>Or do I have to run another query inside the php loop? (I seem to >>remember, from a previous life, that you could do these "queries >> >> >within > > >>queries" in ColdFusion.) >> >> > >Andrew, you cannot do this with MySQL. MySQL does not support nested >queries nor union clauses. You could attempt this with Postgres, but >you still wouldn't be able to have multiple columns from one table all >in one column in a result from another table. The best way to do this >is to use 2 queries if you are using MySQL. If you want to use postgres >you could do this with a stored procedure or a really advanced nested >query but then the nested query would probably run slower than 2 simple >queries. :) > >Good luck >Andrew > > >