Guest User

Untitled

a guest
Oct 23rd, 2018
91
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.40 KB | None | 0 0
  1. [
  2. {
  3. "item": {
  4. "id": 1,
  5. "data": {
  6. "name": "ABC",
  7. "status": "Active"
  8. }
  9. }
  10. },
  11. {
  12. "item": {
  13. "id": 2,
  14. "data": {
  15. "name": "DEF",
  16. "status": "Active"
  17. }
  18. }
  19. }
  20. ]
  21.  
  22. UPDATE my_table SET data = data || '{"name":"GHI"}' WHERE id = 1;
  23.  
  24. knex('my_table')
  25. .update({ data: knex.raw('data || ?', [{ name: 'GHI' }]) })
  26. .where('id', 1);
Add Comment
Please, Sign In to add comment