Open In App

MySQL | VERSION( ) Function

Last Updated : 19 Nov, 2019
Improve
Improve
Like Article
Like
Save
Share
Report

The MySQL Version() function is used for returning the current version of the MySQL database. This function uses the utf8 character set. Generally, there is a suffix returned after the version number. The Version() function does not require any parameter to be passed.

Syntax:

VERSION()

Parameters Used:
It does not require any parameter or argument to be passed.

Return Value:
The MySQL Version() function returns the version of the MySQL database as a string.

Supported Versions of MySQL:

  • MySQL 5.7
  • MySQL 5.6
  • MySQL 5.5
  • MySQL 5.1
  • MySQL 5.0
  • MySQL 4.1
  • MySQL 4.0
  • MySQL 3.23

Example: Implementing Version() function in MySQL.

SELECT VERSION(); 

Output:

5.7.26-0ubuntu0.18.04.1 

Like Article
Suggest improvement
Share your thoughts in the comments

Similar Reads