MySQL Database

6.

SQL Fundamentals: Data Manipulation Language (DML)

6.1.

6.1.1.

Basic INSERT Operations

6.1.1.1.

INSERT INTO VALUES Syntax

6.1.1.2.

Column List Specification

6.1.1.3.

Value List Matching

6.1.2.

Multiple Row Insertion

6.1.2.1.

Bulk Insert Syntax

6.1.2.2.

Performance Benefits

6.1.2.3.

Transaction Considerations

6.1.3.

Alternative INSERT Syntax

6.1.3.1.

INSERT INTO SET Format

6.1.3.2.

Column-Value Pairs

6.1.3.3.

Readability Benefits

6.1.4.

Handling Duplicate Keys

6.1.4.1.

6.1.4.1.1.

Duplicate Key Handling

6.1.4.1.2.

Error Suppression

6.1.4.2.

ON DUPLICATE KEY UPDATE

6.1.4.2.1.

Upsert Operations

6.1.4.2.2.

Conditional Updates

6.1.4.2.3.

Value Expressions

6.1.5.

INSERT with Subqueries

6.1.5.1.

INSERT INTO SELECT

6.1.5.2.

6.1.5.3.

Conditional Insertion

6.2.

6.2.1.

Basic UPDATE Operations

6.2.1.1.

UPDATE SET WHERE Syntax

6.2.1.2.

Single Column Updates

6.2.1.3.

Multiple Column Updates

6.2.2.

Conditional Updates

6.2.2.1.

WHERE Clause Usage

6.2.2.2.

Complex Conditions

6.2.2.3.

Subquery Conditions

6.2.3.

Multi-Table Updates

6.2.3.1.

JOIN-Based Updates

6.2.3.2.

Related Table Updates

6.2.3.3.

Performance Considerations

6.2.4.

Safe Update Practices

6.2.4.1.

Transaction Usage

6.2.4.2.

WHERE Clause Validation

6.2.4.3.

Backup Strategies

6.2.4.4.

sql_safe_updates Mode

6.3.

6.3.1.

Basic DELETE Operations

6.3.1.1.

DELETE FROM WHERE Syntax

6.3.1.2.

Conditional Deletion

6.3.1.3.

All Row Deletion

6.3.2.

Multi-Table Deletes

6.3.2.1.

JOIN-Based Deletes

6.3.2.2.

Related Data Cleanup

6.3.2.3.

Referential Integrity

6.3.3.

Safe Delete Practices

6.3.3.1.

Transaction Protection

6.3.3.2.

WHERE Clause Verification

6.3.3.3.

Backup Procedures

6.3.3.4.

Soft Delete Alternatives

6.3.4.

DELETE vs. TRUNCATE

6.3.4.1.

Performance Differences

6.3.4.2.

Transaction Behavior

6.3.4.3.

Auto-Increment Handling

Previous

5. Data Types and Constraints

Go to top

Next

7. SQL Fundamentals: Data Query Language (DQL)