SQLize Online / PHPize Online  /  SQLtest Online

create table test ( id int, field1 varchar(64), field2 varchar(64),field3 varchar(64) ); insert into test values (1, 'field1.1', 'field2.1', 'field2.1'),(2, 'field1.1', 'field2.1', 'field2.1'); select * from test; select * from json_populate_recordset( NULL::test, '[{"id":1, "field1":"f.1.2", "field2":"f.2.2", "field3":"f.3.2"},{"id":2, "field1":"f.1.4", "field2":"f.2.5", "field3":"f.3.6"}]' ); update test set field1 = data.field1, field2 = data.field2, field3 = data.field3 from (select * from json_populate_recordset( NULL::test, '[{"id":1, "field1":"f.1.2", "field2":"f.2.2", "field3":"f.3.2"},{"id":2, "field1":"f.1.4", "field2":"f.2.5", "field3":"f.3.6"}]' )) data where test.id = data.id; select * from test;