MySQL Basic Operation _mysql

Under window, start and stop MySQL service

Start the MySQL database
net start MySQL

Stop MySQL Database
net stop MySQL

Restart the MySQL database
NET restart MySQL


command line form, use of MySQL basic commands

1, the cancellation of the order
\c

2, exit the MySQL window
exit; or quit; CTRL + C

3, view the database version number
Select version ();

4, display the current existing database
show databases;

5. Choose Test Database
Use test;

6, view the selected database
Select Database ();

7, set up the database Chinese code
Set names UTF8;

8. Create a test database
Create DATABASE Test

9, create a mtest table
CREATE TABLE Mtest (
ID tinyint (2) unsigned NOT NULL auto_increment,
Name varchar (20),
Sex char (1),
Email varchar (50),
Birth datetime,
Primary KEY (ID)
);

10. Insert a piece of data into the Mtest table
Insert into Mtest (' name ', ' sex ', ' email ', ' birth ') VALUES (' Zhangsan ', ' 1 ', ' zhangsan@163.com ', now ());

11, the Query mtest table name is John Information
SELECT * from mtest where name= ' Zhangsan ';

12. Output in descending order of ID number
SELECT * from mtest ORDER by id DESC;

13, display 11th to 20th data information
SELECT * FROM Mtest ID limit 10, 10;