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
Select @@version as version
It will display the current version of the MySQL Server
There is another function named version()
Select version() as version
The above produces the same result as @@version
You can also use another method to know this
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)