In SQL Server, to know the current version of the server, you can use system variable @@VERSION
How many of you know that the same can be used in mysql to know the version?
Also there are many ways to know the version of MySQL
Method 1:
Select @@version as version
It will display the current version of the MySQL Server
There is another function named version()
Method 2:
Select version() as version
The above produces the same result as @@version
You can also use another method to know this
Method 3:
Show variables like '%version%'
The above returns a resultset with two columns variable_name and value. You can find the version where variable_name says version.
Reference:Â Pinal Dave (https://blog.sqlauthority.com)
