Firebird 2.5 Language ReferenceFirebird 2.5 Language Reference → Data Manipulation (DML) Statements
Firebird Firebird Prev: COMMENTSFirebird 2.5 Language ReferenceUp: Firebird 2.5 Language ReferenceNext: SELECT

Chapter 6: Data Manipulation (DML) Statements

Table of Contents

SELECT
FIRST, SKIP
The SELECT Columns List
The FROM clause
Joins
The WHERE clause
The GROUP BY clause
The PLAN clause
UNION
ORDER BY
ROWS
FOR UPDATE [OF]
WITH LOCK
INTO
Common Table Expressions (“WITH ... AS ... SELECT”)
INSERT
INSERT ... VALUES
INSERT ... SELECT
INSERT ... DEFAULT VALUES
The RETURNING clause
Inserting into BLOB columns
UPDATE
Using an alias
The SET Clause
The WHERE Clause
The ORDER BY and ROWS Clauses
The RETURNING Clause
Updating BLOB columns
UPDATE OR INSERT
The RETURNING clause
DELETE
Aliases
WHERE
PLAN
ORDER BY and ROWS
RETURNING
MERGE
EXECUTE PROCEDURE
Executable” Stored Procedure
EXECUTE BLOCK
Input and output parameters
Statement Terminators
[Important] REVIEW STATUS

All sections from this point forward to the end of the chapter are awaiting technical and editorial review.

DML—data manipulation language— is the subset of SQL that is used by applications and procedural modules to extract and change data. Extraction, for the purpose of reading data, both raw and manipulated, is achieved with the SELECT statement. INSERT is for adding new data and DELETE is for erasing data that are no longer required. UPDATE, MERGE and INSERT OR UPDATE all modify data in various ways.

Prev: COMMENTSFirebird 2.5 Language ReferenceUp: Firebird 2.5 Language ReferenceNext: SELECT
Firebird 2.5 Language ReferenceFirebird 2.5 Language Reference → Data Manipulation (DML) Statements