MySQL Database knowledge system

MySQL Data

1. Database definition language (data Definition language DDL)

A. Alter DATABASE

B. Create Database

C. Drop database

d. ALTER TABLE

E. CREATE table

F. drop table

G. Rename table

H. CREATE index

I. DROP Index

2. Data manipulation Language (DML)

A. Delete

B. Do

C. Handler

D. Insert

E. Load Data infile

F. Replace

G. Select

H. subquery

I. Truncate

J. Update

3. mysql tools, transactions, locking

A. Describe

B. Use

C. Start transaction, Commit, rollback

D. savepoint, rollback to SavePoint

E. Lock tables, unlock tables

F. Set transaction

4. mysql Account management

A. Create user

B. Drop user

C. Grant, REVOKE

D. Rename User

E. Set Password

5. mysql table maintenance, set, show

A. Analyze table

B. Backup table

C. Check table

D. Checksum table

E. Optimize table

F. Repair table

G. Restore table

H. Set

I. Show

First, the database

Second, data table

Third, index

Four, view

V. Business

VI. triggers

Vii. stored procedures/instances/functions

MySQL Database knowledge system