MySQL | VERSION( ) Function

MySQL | VERSION( ) Function

Last Updated : 19 Nov, 2019

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

MySQL | VERSION( ) Function

S

Shubrodeep Banerjee

Improve

Article Tags :

Similar Reads

MySQL NOW() function

The NOW() function in MySQL is a powerful tool that returns the current date and time based on the server's time zone. This function is widely used when you need to capture the exact moment an event occurs such as when recording timestamps for records like orders, deliveries, or log entries. In this

MySQL | SHA1( ) Function

The MySQL SHA1() function is used for encrypting a string using the SHA-1 technique. The SHA1 stands for secure hash algorithm and it produces a 160-bit checksum for a user inputted string. The MySQL SHA1() function returns NULL if the string passed as an argument is a NULL string. The SHA1() functi

SECOND() Function in MySQL

SECOND() function in MySQL is used to return the second portion of a specified time or date-time value. The first parameter in this function will be the date/Date Time. This function returns the seconds from the given date value. The return value (seconds) will be in the range of 0 to 59. In this fu

PLSQL | SIGN Function

The PLSQL SIGN function is used for returning a value which indicates the sign of a number. The SIGN function accepts one parameter which is the number whose sign needs to be known. The SIGN function returns a value of the numeric data type. This function takes as an argument any numeric data type a

YEAR() Function in MySQL

YEAR() function in MySQL is used to find year from the given date. If the date is NULL, the YEAR() function will return NULL. Otherwise, it returns value range from 1000 to 9999. Syntax : YEAR(date) Parameter : This method accepts one parameter as mentioned above and described below : date : The dat