Collections:
VERSION() - Version Number of MySQL Server
How to obtain the version number of the MySQL server using the VERSION() function?
✍: FYIcenter.com
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
2023-12-19, 268🔥, 0💬
Popular Posts:
What Are Date and Time Functions in MySQL? MySQL offers a number of functions for date and time valu...
How To Break Query Output into Pages in MySQL? If you have a query that returns hundreds of rows, an...
How to set database to be READ_ONLY in SQL Server? Databases in SQL Server have two update options: ...
Can You Drop an Index Associated with a Unique or Primary Key Constraint in Oracle? You can not dele...
How to set database to be READ_ONLY in SQL Server? Databases in SQL Server have two update options: ...