SQLite 3.39

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE employee (id INTEGER PRIMARY KEY, name TEXT, savecounter INTEGER NOT NULL DEFAULT 0);
✓
CREATE TRIGGER emp_reset_savecounter AFTER UPDATE OF savecounter ON employee
BEGIN
  SELECT CASE WHEN NEW.savecounter = 0 THEN RAISE(IGNORE) END;
  SELECT CASE WHEN (SELECT MIN(savecounter) FROM employee) = 0 THEN RAISE(IGNORE) END;
  UPDATE employee SET savecounter = 0;
END;
✓
INSERT INTO employee(name) VALUES
  ('name1'), ('name2'), ('name3');
✓
SELECT * FROM employee;


id
name
savecounter


1
name1
0

2
name2
0

3
name3
0


UPDATE employee SET savecounter = 1 WHERE id = 1;
✓
SELECT * FROM employee;


id
name
savecounter


1
name1
1

2
name2
0

3
name3
0


UPDATE employee SET savecounter = 1 WHERE id = 2;
✓
SELECT * FROM employee;


id
name
savecounter


1
name1
1

2
name2
1

3
name3
0


UPDATE employee SET savecounter = 1 WHERE id = 3;
✓
SELECT * FROM employee;


id
name
savecounter


1
name1
0

2
name2
0

3
name3
0