Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- [
- {
- "item": {
- "id": 1,
- "data": {
- "name": "ABC",
- "status": "Active"
- }
- }
- },
- {
- "item": {
- "id": 2,
- "data": {
- "name": "DEF",
- "status": "Active"
- }
- }
- }
- ]
- UPDATE my_table SET data = data || '{"name":"GHI"}' WHERE id = 1;
- knex('my_table')
- .update({ data: knex.raw('data || ?', [{ name: 'GHI' }]) })
- .where('id', 1);
Add Comment
Please, Sign In to add comment