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

Posted by Pinal Dave on SQL Authority See other posts from SQL Authority or by Pinal Dave
Published on Sat, 09 Nov 2013 01:30:48 +0000 Indexed on 2013/11/09 4:05 UTC
Read the original article Hit count: 337

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

© SQL Authority or respective owner

Related posts about mysql

Related posts about PostADay