Cry MySQL How to...

Determine which version of MySQL you are connected to

To determine which version of MySQL you are connected to, use the following SQL:

select version();

This will return a single result (for example "4.0.16-nt") containing the MySQL version number.

These notes have been tested against MySQL version 4 and 5.