MySQL Learning (1)

1. Start MySQL service: net start MySQL

Turn off MySQL service: net stop MySQL

2, Login mysql:mysql-uroot-p (Enter, password +enter)

Mysql-h Server IP address (default localhost)-p port number (default 3306)-u user name-p password

3, display database: show databases;

4. Creating database: Create database name;

5. Using/Switching database: Use database name;

6, delete the database: drop database name;

7. Data type:

Shaping: tinyint, smallint, mediumint, int, bigint

Character type: char (m), varchar (m)

Float type: float (m,n), double (m,n)

(Other slightly)

8, the constraints of the table:

Primary key: Primary key

Non-empty: NOT NULL

Unique: Unique

Self-growth: auto_increment

FOREIGN key: FOREIGN key

9. Display all tables in the database: show tables;

10. Create a table:

CREATE TABLE table name (Field 1 field type, field 2 field type, ...);
such as: CREATE TABLE student (ID int auto_increment PRIMARY KEY, Tname varchar (), age tinyint unsigned);

　　

　

MySQL Learning (1)