Shulou(Shulou.com)05/31 Report--

This article mainly introduces how to use batch processing to start the MySQL command line tool, has a certain reference value, interested friends can refer to, I hope you can learn a lot after reading this article, the following let the editor take you to understand it.

Recently, I have been watching MySQL. After installation, every time I start the MySQL command line tool on the start menu, I connect to my local user directly with the root user.

Enter the password to start working, but to connect to the MySQL on the server, run it under CMD: MySQL-- h272.18.1.22-uroot-p123456

Each input is naturally boring, batch processing to solve this problem, first code:

-

@ echo off

Set / p var= "Please press 1 for local MySQL, 2 for 172.18.1.22 server, and 0 for exit."

If VAR%==1 GOTO Local

If VAR%==2 GOTO Server22

If VAR%==0 GOTO End

: Local

Start "Local"D:ProgramMySQLinMySQL.exe"-uroot-p123456

Goto End

: Server22

Start "Server23"D:ProgramMySQLinMySQL.exe"-h272.18.1.22-uroot-p123456

Goto End

: End

In this batch processing, it is first used to wait for keyboard input to control the process. In this case, enter 1pm 2p0 to control the flow, without dealing with other cases.

Enter 1 and press enter, and the code will go to the start exe file according to your input. In this case, there are parameters.

When this console appears, it is explained here that this console is newly opened, and the previous one has been closed because it is no longer useful to me. If you still want to use it, you can control it under the end tab.

Thank you for reading this article carefully. I hope the article "how to start the MySQL command line tool with batch processing" shared by the editor will be helpful to you. At the same time, I also hope you will support us and pay attention to the industry information channel. More related knowledge is waiting for you to learn!

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.