Three ways to check the version of MySQL database
Three ways to view MySQL database versions
1. Use the-V parameter
The first thing that comes to mind is definitely the command to check the version number parameter, the parameter is-V (capital letter) or--version
How to use:
D:xamppmysqlbin>mysql -V
or
D:xamppmysqlbin>mysql --version
2) Use of-? parameters
Actually, there are three similar parameters.
--help
-I (capital i)
-?
All three are parameters for viewing help information
How to use:
D:xamppmysqlbin>mysql -?
or
D:xamppmysqlbin>mysql --help
or
D:xamppmysqlbin>mysql -I
3. SQL statement for querying version information
select version();
Of course, there are other ways to indirectly view the version information of mysql database, such as using status;, etc., but these three methods are the most convenient and direct.
[@more@]
