SQL · System and metadata

changes()

The number of rows changed by the most recent statement. SQLite.

sqlRunnable example sql course

Syntax

changes()

Example

Open in the lab

CREATE TEMP TABLE notes (body TEXT);
INSERT INTO notes VALUES ('a'), ('b');
SELECT changes() AS changed;

Reference pages are the quick answer. The course explains the why, shows the full example and ends with a challenge.