Earlier I wrote an article about Detecting Current Version of MySQL Server Installation. After the post quite a few emails I received where various users suggested that there are many more ways to figure out the version of MySQL. Here are few of the methods which I received in the email.

Method 1:

This method retrieves value with the help of Information Functions.

SELECT VERSION();

Method 2:

This method is very similar to SQL Server.

SELECT @@Version

Method 3:

You can connect to MySQL with command prompt and type following command:

STATUS;

Method 4:

Please refer my earlier blog post.

SHOW VARIABLES LIKE "%version%";

Let me know if you know any more method and I will extend this blog post.

Reference : Pinal Dave (http://blog.SQLAuthority.com)

Filed under: MySQL, PostADay, SQL, SQL Authority, SQL Query, SQL Tips and Tricks, T SQL