You can also use BEGIN TRANSACTION
before the operation is executed. You can see the number of rows affected. From there, either COMMIT
the results or use ROLLBACK
to put the data back in the original state.
BEGIN TRANSACTION;
UPDATE table
SET col = 'something'
WHERE col2 = 'something else';
Review changed data and then:
COMMIT;
or
ROLLBACK;
与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…