Python SQLite3 - INSERT-WHERE Workaround

Solution 1:

I think you want an update here:

UPDATE yourTable
SET date = '2021-01-13', duration = 36.8
WHERE family = 'FAA' AND model = 'MAA';

Solution 2:

You want to update your table, insert is only for new rows. When you want to change a value, you must to use update statement.

UPDATE table_name
   SET date = '2021-01-13', duration = '36.8'
 WHERE  family='FAA' AND model='MAA';

https://www.sqlite.org/lang_update.html