changes
The .changes
command toggles the display of the number of rows affected by SQL statements (such as INSERT, UPDATE,
DELETE). This feedback is useful for verifying the impact of your queries, especially in data modification or ETL
workflows.
Usage
.changes <on|off>
When to use
- Enable
.changes on
to always see how many rows were changed by your queries—helpful for auditing and debugging. - Disable
.changes off
for a cleaner output if you do not need this information.
Examples
Show the current changes setting:
.changes
Turn on the rows changed display:
.changes on
Turn off the rows changed display:
.changes off
Troubleshooting
- If you do not see row change counts, ensure
.changes on
is set. - Some drivers or read-only queries may not report row changes.
Related
- See the
changes
option in rsql.toml configuration. - For output customization, see format and footer.