MYSQL – Identifying Current Version of MySQL Server Installation – Part 2

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)

About these ads

One thought on “MYSQL – Identifying Current Version of MySQL Server Installation – Part 2

  1. Curious results when using:
    SELECT @@VERSION AS [SQL Version Info];

    SELECT SERVERPROPERTY(‘productversion’), SERVERPROPERTY (‘productlevel’), SERVERPROPERTY (‘edition’)

    Option one returns info that suggest we are on SP2 – whereas the second option returns the correct SP (4)

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s