return updated rows using mysql/nodejs

Question

Using mysql end nodejs , how can I get the entire updated rows ?

var query2 = connection.query('UPDATE campaigns SET USED=0 where amount=?' , [amount], function (error, results, fields) {
                console.log(query2.sql);
                if (error) throw error;

// Get here all updated rows

}

With affectedRows, I can get only the number of updated rows.

score 0 · Answer 1 · answered Jun 28 '19 at 10:58

0

you can select all row's ids before update, then update them and then select them by ids

1st step: select id from campaigns where amount=?

2nd step: update campaigns set USED=0 where amount=?

3d step: select * from campaigns where id in (<ids from 1st step>)

answered Jun 28 '19 at 10:58

Alexey Semerenko

132
1
6

1

there is no other way to avoid this first query ? – dt dino Jun 28 '19 at 13:16
found similar post https://stackoverflow.com/questions/11477121/mysql-return-updated-rows – Alexey Semerenko Jun 28 '19 at 16:13

return updated rows using mysql/nodejs

1 Answers1