By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE data(id INTEGER PRIMARY KEY, name TEXT NOT NULL DEFAULT '');
✓
CREATE TRIGGER trg_after_insert_data AFTER INSERT ON data
WHEN NEW.name = ''
BEGIN
UPDATE data
SET name = 'Data' || NEW.id
WHERE id = NEW.id;
END;
✓
INSERT INTO data DEFAULT VALUES;
✓
SELECT * FROM data;
| id | name |
|---|---|
| 1 | Data1 |
INSERT INTO data DEFAULT VALUES;
✓
SELECT * FROM data;
| id | name |
|---|---|
| 1 | Data1 |
| 2 | Data2 |