Overview

Level-2 directory

Topic

Design a database object

Create a database

Create a table

Create indexes

Level-2 directory

Topic

Data writing

Insert data

Update data

Delete data

Replace data

Level-2 directory

Level-3 directory/Topic

Topic

Data reading

About queries

Single-table queries

Conditional queries

ORDER BY queries

GROUP BY queries

Use Row_Limiting_Clause in queries

Multi-table JOIN query

INNER JOIN queries

FULL JOIN queries

LEFT JOIN queries

RIGHT JOIN queries

Subqueries

Use operators and functions in query

Use arithmetic operators in queries

Use numerical functions in queries

Use string concatenation operators in queries

Use string functions in queries

Use datetime functions in queries

Use type conversion functions in queries

Use aggregate functions in queries

Use NULL-related functions in queries

Use the CASE conditional operator in queries

Use the SELECT FOR UPDATE statement to lock query results

Execution plan

View an execution plan

Understand an execution plan

Use SQL hints in queries

Variables of query timeout

Level-2 directory

Level-3 directory/Topic

Topic

Manage transactions

Overview

Start a transaction

Savepoints

Mark a savepoint

Roll back a transaction to a savepoint

Release a savepoint

Commit a transaction

Roll back a transaction