changes

Usage

.changes <on|off>

Description

The changes command toggles the display of the number of rows changed by a SQL statement. When the display is turned on, the number of rows changed is displayed after the execution of a SQL statement. When the display is turned off, the number of rows changed is not displayed.

Examples

Show the current changes setting:

.changes

Turn on the rows changed display:

.changes on

Turn off the rows changed display:

.changes off

Demonstration