SQLite User Forum

Efficiency of updates versus replace when using the JSON1 extension functions.
Login
Thank you for the explanation. 

If the table is only two columns, such as create table t (id integer primary key, b jsontext ); and the json string in column b is to be completely replaced without the use of any JSON1 extension functions, will the existing record be deleted and the new one added without the need for table new_t?