4 replies

Update many rows

Is it possible to update many rows in the table using db.update(table).set(...).from() ?

Specifically I want to achive this sql query:

UPDATE users u
SET
  score   = v.new_score,
  status  = v.new_status,
  rank    = v.new_rank
FROM (
  VALUES
    (1, 100, 'active',  5),
    (3,  85, 'inactive', 7),
    (5, 120, 'pending', 3)
) AS v(id, new_score, new_status, new_rank)
WHERE u.id = v.id
RETURNING *

UPDATE users u
SET
  score   = v.new_score,
  status  = v.new_status,
  rank    = v.new_rank
FROM (
  VALUES
    (1, 100, 'active',  5),
    (3,  85, 'inactive', 7),
    (5, 120, 'pending', 3)
) AS v(id, new_score, new_status, new_rank)
WHERE u.id = v.id
RETURNING *

But cannot get

.from

.from

working.

Drizzle Team•6mo ago•

4 replies

Valerka

Update many rows

Is it possible to update many rows in the table using db.update(table).set(...).from() ?

Specifically I want to achive this sql query:

UPDATE users u
SET
  score   = v.new_score,
  status  = v.new_status,
  rank    = v.new_rank
FROM (
  VALUES
    (1, 100, 'active',  5),
    (3,  85, 'inactive', 7),
    (5, 120, 'pending', 3)
) AS v(id, new_score, new_status, new_rank)
WHERE u.id = v.id
RETURNING *

UPDATE users u
SET
  score   = v.new_score,
  status  = v.new_status,
  rank    = v.new_rank
FROM (
  VALUES
    (1, 100, 'active',  5),
    (3,  85, 'inactive', 7),
    (5, 120, 'pending', 3)
) AS v(id, new_score, new_status, new_rank)
WHERE u.id = v.id
RETURNING *

But cannot get

.from

.from

working.

Update many rows

Similar Threads

Update many rows

Similar Threads

Similar Threads

Similar Threads