René Fournier wrote:
...that is the question.
I have some queries that would possibly benefit from subqueries, which
means upgrading my stock Mac OS X Server 10.3.9 installation of MySQL
(version 4.1.10a).
The question is, and I would appreciate any comments, should I go just
to 4.0.26 for the subqueries, or straight to 5.0.15?
Also, the machine I am upgrading is a production box, so I am a little
nervous about what can (and will) go wrong. Any good advice is much
appreciated. Thanks.
...Rene
Mysql supports subqueries starting with 4.1. 4.0 does not support subqueries.
So, if you have 4.1.10a, you already have subquery support, and changing from
4.1.10a to 4.0.26 would be a downgrade, not an upgrade.
On the other hand, as I understand it, a stock 10.3.9 server has mysql 4.0.16.
4.1.10a is the version on a stock 10.4.0 server (which is updated to 4.1.13 with
one of the security updates to 10.4, if I recall correctly).
Michael
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
