What is the command for mysql version query?

The mysql version query command is "select version();" or "status". Specific query method: 1. Open the mysql console and enter the password; 2. Enter the "select version();" or "status" command and press Enter to view the mysql version number.

The operating environment of this tutorial: windows7 system, mysql5.6.16 version, Dell G3 computer.

mysql version query

Open the mysql console on our computer and enter the password, as shown below:

Enter the "select version();" command and press the Enter key, as shown below:

##You can see the version number of mysql, as shown in the figure below:

We can also enter the "status" command and press the Enter key, as shown in the figure below:

You can see that the version number of mysql is 5.6.16, as shown below:

##Related free learning recommendations :

mysql video tutorial

The above is the detailed content of What is the command for mysql version query?. For more information, please follow other related articles on the PHP Chinese website!