Windows environment variables

1, consider the following requirements, after entering CMD, I would like to execute the MySQL client command, and this need to go to the MySQL installation directory, find the MySQL executable file, in this directory to execute the MySQL command. Is it too much trouble to have a good solution?

2, using environment variables, the variable name is mysql_home, the variable value is C:\Program Files (x86) \mysql\mysql Server 5.5\bin, on the Windows command line, execute CD%mysql_home%, go to the corresponding directory , execute the MySQL client command. Note: The reference environment variable in VS uses $ (mysql_home)

3, another simpler way, modify the environment variable path, add a C:\Program Files (x86) \mysql\mysql Server 5.5\bin; Use a semicolon interval between the values, and this is the same as the path in the batch, as follows Path=: /common, .... /IBP_SDK;

Windows environment variables