SQLite 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?