guelphdad
07-16-2006, 04:57 PM
The lastest full production release of MySQL is version 5.
Some hosts do not support version 5 yet but most should be supporting version 4.1.
If your version is older than 4.1 please note that in any new threads you start. This is because older versions do not support things like GROUP_CONCAT and subqueries among other things.
If you happen to still be on MySQL 3.x then you won't even have the ability to use UNION.
If you note that you are using an older version, then when someone is composing a solution to help you, they will give you a version that you can use on your particular release of MySQL.
Subqueries can be re-written as joins and in place of a UNION you may create a temporary table and then query results from it for instance.
Some hosts do not support version 5 yet but most should be supporting version 4.1.
If your version is older than 4.1 please note that in any new threads you start. This is because older versions do not support things like GROUP_CONCAT and subqueries among other things.
If you happen to still be on MySQL 3.x then you won't even have the ability to use UNION.
If you note that you are using an older version, then when someone is composing a solution to help you, they will give you a version that you can use on your particular release of MySQL.
Subqueries can be re-written as joins and in place of a UNION you may create a temporary table and then query results from it for instance.