Dynamically update SQLite row based on column values

Question

Is it possible for SQLite to dynamically insert/update values in the row of a table based on other columns within that row? Best illustrated with a simple example

CREATE TABLE family(first TEXT, last TEXT, full TEXT *magical specification);

INSERT INTO family (first,last) VALUES ('foo','bar')

And have the table automatically fill in the third column with a combination of the other two:

  first        last         full
---------  ------------  -----------
  foo          bar         foo bar

CL. · Accepted Answer · 2014-12-02 23:39:12Z

1

You could use a trigger:

CREATE TRIGGER family_full
AFTER INSERT ON family
FOR EACH ROW
WHEN NEW.full IS NULL
BEGIN
    UPDATE family
    SET full = first || ' ' || last
    WHERE rowid = NEW.rowid;
END;

answered Dec 2, 2014 at 23:39

CL.

182k18 gold badges241 silver badges282 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Dynamically update SQLite row based on column values

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related