MySQL Learning notes--operations on the database

First, start/Shut down the database service:

1. Open cmd Command Prompt window

2, enter the command net start MySQL , enter, then started the MySQL service

3. After entering the command net stop MySQL , enter, then turn off the MySQL service

Second, the login database

1. Open cmd Command Prompt window

2. Start MySQL service net start MySQL

3. Login Input command mysql-u user name (e.g. root)-P Enter

4, enter the corresponding password, return

Third, create the database

Command:create database name;

Where the database name is a special case, you should include it with the anti-quote ' ' .

Special cases include:

1, Pure Digital

2. Special symbols

3. mysql internal key words

4. Chinese

Iv. viewing the currently existing database

Command: show databases;

V. View the creation statement for the database

Command: show create database name;

Vi. Modifying the database character set

Command:ALTER DATABASE name character set GBK;

Vii. deletion of databases

Command:drop database name;

MySQL Learning notes--operations on the database