MySQL Development guide

Database development is a database management system (DBMS) and database application software design and development of the general term, data operation and maintenance, participate in the database production environment problem optimization and resolution issues.

1. About MySQL Database

2. Build MySQL Environment

3, the introduction of common SQL, the use of official documents

For development purposes:

　　SQL is the foundation of the Foundation!!!

SQL is the standard language for manipulating and retrieving relational databases, and standard SQL statements can be used to manipulate relational databases.

The following is a MySQL-based SQL analysis study:

First, DQL (data query Language) statement

Mainly because the Select keyword is complete, the query statement is the most complex and feature-rich statement in the SQL statement.

1. Basic Select Instance

2. mysql operator

3. Commonly used String functions

4. Common numerical functions

5. Common date and Time functions

6. Process functions in Select

7. Grouping aggregation functions

8. Select Multi-table connection query

9. Select Sub-query

10. Row to column and line change enquiry

Second, DML (data munipulation Language) statement

The data will be consistent after the DML statement is modified, and the statement of the action table, such as inserting inserts, updating update, deleting delete, etc.

1. Add: Insert, replace

2. Delete: Update

3, change: Delete, truncate

Third, DDL (data definition Language) statements

Manipulate the language of the data object, including creating create, deleting drop, and modifying the ALTER database object.

1. Common data types

2. Character set and proofreading rules

3. Using DDL statements to build a table

4, temporary table creation and the old table to build a new table

5. Common construction table options and constraints

6. Deletion and modification of tables

7. mysql View

Iv. DCL (Data Control Language) statements

There are mainly grant, revoke statements.

1. User authentication and authority control

V. MySQL processing program

Handlers: A set of programmable functions that are set of SQL statements to complete a particular function.

1. Creation and invocation of stored procedures

2. Variable definition

3. Process Control Statements

4. Custom MySQL Functions

5. Use of SELECT INTO in a stored procedure

6. Exception Handling

7, the simple practice of cursors

8. Checking, changing and deleting stored procedures

9, the use of trigger trigger

10. Use of Scheduler Event

Six, written in the back

1. MySQL Development summary

2, SQL syntax Example: practice, very important.

Easter eggs:mysql self-growing bug?

---What we should do is not the vague things in the distance, but the certainty of things at hand.

MySQL Development guide