General MySQL Oracle SQL Server

VERSION() - Version Number of MySQL Server

Q

How to obtain the version number of the MySQL server using the VERSION() function?

✍: FYIcenter.com

A

VERSION() is a MySQL built-in function that returns the version number of the MySQL server. For example: 

SELECT VERSION();
  -- +-----------+
  -- | VERSION() |
  -- +-----------+
  -- | 8.0.17    |
  -- +-----------+

SELECT @@version; 
  -- +-----------+
  -- | @@version |
  -- +-----------+
  -- | 8.0.17    |
  -- +-----------+

Reference information of the VERSION() function: 

VERSION(): ver
  Returns the version number of the MySQL server.

Arguments, return value and availability:
  ver: Return value. The version number of the MySQL server.
  Available since MySQL 4.0.

 

⇒ MySQL Functions for Miscellaneous Purposes

⇐ USER() - Login Name of Current User

⇑ MySQL Functions on System Information

⇑⇑ MySQL Function References

2023-12-19, 256🔥, 0💬

General MySQL Oracle SQL Server