Simple operation of MySQL under CMD

First, click Windows+r, search cmd, open

650) this.width=650; "src=" Https://s1.51cto.com/wyfs02/M02/95/D6/wKiom1kacNLhM2niAABSctRtSHQ982.png "title=" 1.PNG "Width=" "height=" 213 "border=" 0 "hspace=" 0 "vspace=" 0 "style=" width:400px;height:213px; "alt=" Wkiom1kacnlhm2niaabsctrtshq982.png "/>

After entering Cmd.exe, enter mysql-u root-p on the command line; Click Enter

But I had the following error message when I was testing,

650) this.width=650; "src=" Https://s4.51cto.com/wyfs02/M02/95/D6/wKioL1kaclXzd8MIAAATaL1W6ps907.png "title=" 2.PNG "Width=" "height=" "border=" 0 "hspace=" 0 "vspace=" 0 "style=" width:400px;height:84px; "alt=" Wkiol1kaclxzd8miaaatal1w6ps907.png "/>

But don't worry, windows+r again, search for service.msc, open find MySQL service, turn off the service, and turn it back on

650) this.width=650; "src=" Https://s3.51cto.com/wyfs02/M01/95/D7/wKioL1kacxvi-yE3AAMPKea_HUg689.png "title=" 3.PNG "Width=" height= "border=" 0 "hspace=" 0 "vspace=" 0 "style=" width:400px;height:180px; "alt=" Wkiol1kacxvi-ye3aampkea_hug689.png "/>

Enter mysql-u again on the command line of CMD root-p

650) this.width=650; "src=" Https://s3.51cto.com/wyfs02/M00/95/D7/wKioL1kac5TjVFeRAABHe5KaW7E865.png "title=" 4.PNG "Width=" "height=" 206 "border=" 0 "hspace=" 0 "vspace=" 0 "style=" width:400px;height:206px; "alt=" Wkiol1kac5tjvferaabhe5kaw7e865.png "/>

Next, look at the MySQL surface of the databases, the same input command, show databases; (Be sure to add it at the end of the command)

650) this.width=650; "src=" Https://s2.51cto.com/wyfs02/M01/95/D7/wKioL1kadBej5wFrAAAbkLdTqLI123.png "title=" 5.PNG "Width=" "height=" 265 "border=" 0 "hspace=" 0 "vspace=" 0 "style=" width:400px;height:265px; "alt=" Wkiol1kadbej5wfraaabkldtqli123.png "/>

In the next, command line input, use test; and show tables;

650) this.width=650; "src=" Https://s3.51cto.com/wyfs02/M00/95/D7/wKioL1kadHPDC5IjAAAdu5jrW2s847.png "title=" 6.PNG "Width=" "height=" 294 "border=" 0 "hspace=" 0 "vspace=" 0 "style=" width:400px;height:294px; "alt=" Wkiol1kadhpdc5ijaaadu5jrw2s847.png "/>

In the next, we can operate the table, using the database of the select,insert,delete operation, such as

Simple operation of MySQL under CMD