Shulou(Shulou.com)06/01 Report--

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@]

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.