How to populate 2 columns of different tables with the same sqllite3 data at the same time?

Question

SQLite

How to populate 2 columns of different tables with the same sqllite3 data at the same time? i.e. entering data into one table (such as autoincrement) in one column, so that the same data as a foreign key was written in another table automatically?

Answer 1

you create a trigger before insert (and on update too) and write the necessary code there, the data will be available from the 'table' new type insert into table_b (id, new_val) values ​​(new.id, new.val)