MySQL Database How-to Articles and Tutorials



Prerequisites

1. Prerequisites for MySQL Query Practices

Database Design

1. How to Design Relational Database

2. Enforce Data Integrity by Database Constraints

3. How to Enforce Data Type Constraint

4. How to Enforce Default Constraint and Nullability Constraint

5. Primary Key Constraint and Unique Constraint

6. Foreign Key Relationships and Considerations

Single Table SELECT Statement

1. The Basic SELECT Statement

2. Using Column Alias in SELECT

3. Using Literal Strings

4. Perform Arithmetic Operations

5. Use WHERE Clause to Conditionally Select Rows

6. Sorting Data

7. Using LIMIT Clause to Constrain the Number of Rows Retrieved

8. Using Comparison Operators, Part I

9. Using Comparison Operators, Part II

10. Using LIKE Comparison Operator

11. Using Logical Operators

12. Eliminating Duplicate Rows

Using Single-Row Functions

1. Using String Functions, Part 1

2. Using String Functions, Part 2

3. Using String Functions, Part 3

4. Using Date and Time Functions, Part 1

5. Using Date and Time Functions, Part 2

6. Using Date and Time Functions, Part 3

7. Using Control Flow Functions

8. Using Conversion Functions

9. Using Comparison Functions

10. Using Miscellaneous Functions

11. Using LIMIT and SQL_CALC_FOUND_ROWS and FOUND_ROWS() to Page Thru Query Result

Querying Multiple Tables

1. Using Inner Joins

2. Using Outer Joins

3. Join a Table to Itself

4. Combine Result Sets by Using UNION

Using Subquery

1. What is subquery

2. Using subquery in WHERE clause

   1. Using subquery to return a single value (known as single-value subquery or scalar subquery)

   2. Using subquery to return a list of values (known as column subquery)

   3. Using subquery to return one ore more rows of values (known as row subquery)

   4. Using correlated subqueries

   5. Using EXISTS and NOT EXISTS in correlated subqueries

3. Using subquery in SELECT statement

4. Using subquery in FROM clause

5. JOIN a table with a subquery

Summarizing Data

1. Using Aggregate Functions

2. More About GROUP BY Clause

3. Using GROUP BY with HAVING Clause

4. Summarizing Data From Multiple Tables

Data Manipulation

1. Update Statement

2. Insert Statement

3. Delete Statement

4. Using Bulk Insert Statement

5. Using LAST_INSERT_ID()

6. Execute Batch SQL

7. Using SELECT INTO to Create a Table

Database Table Indexes

Stored Procedures

User-defined Functions