[TriLUG] MySQL features: subqueries

[Jeremy Portzer]

Recently on this list, we were comparing RDBMS tools (MySQL, Postgresql,
etc).  One of the drawbacks to MySQL has been that it doesn't support
subqueries, for example "SELECT * FROM t1 WHERE t1.a=(SELECT t2.b FROM
t2);"

However, a new version of MySQL (4.1.0) was released today that does
support subqueries.  It's still unstable/alpha, but it's worth keeping
an eye on.

See the full announcement here:
http://lists.mysql.com/list.php?2:mss:161:200304:bhkjccaocblkljhpcfdf

--Jeremy

-- 
/=====================================================================\
| Jeremy Portzer       jeremyp at pobox.com       trilug.org/~jeremy     |
| GPG Fingerprint: 712D 77C7 AB2D 2130 989F  E135 6F9F F7BC CC1A 7B92 |
\=====================================================================/
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 189 bytes
Desc: This is a digitally signed message part
URL: <http://www.trilug.org/pipermail/trilug/attachments/20030409/a98c50bb/attachment.pgp>