Chapter 6: Data Manipulation (DML) Statements

Firebird 2.5 Language Reference → Firebird 2.5 Language Reference → Data Manipulation (DML) Statements

Firebird

Chapter 6: Data Manipulation (DML) Statements

Table of Contents

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 ... VALUES
INSERT ... SELECT
INSERT ... DEFAULT VALUES
The RETURNING clause
Inserting into BLOB columns

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

Aliases
WHERE
PLAN
ORDER BY and ROWS
RETURNING

EXECUTE PROCEDURE

“Executable” Stored Procedure

EXECUTE BLOCK

Input and output parameters
Statement Terminators

	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.

Firebird 2.5 Language Reference → Firebird 2.5 Language Reference → Data Manipulation (DML) Statements