Updating MySQL returns rows affected, but doesn't actually update the Database [ nodejs mysql2 ]

Asked Mar 06 '19 at 09:04

Active Jun 15 '22 at 03:30

Viewed 933 times

I have a function to run mysql2 nodejs with promise and update query

Here is the output:

{
        "fieldCount": 0,
        "affectedRows": 1,
        "insertId": 0,
        "info": "Rows matched: 1  Changed: 1  Warnings: 0",
        "serverStatus": 3,
        "warningStatus": 0,
        "changedRows": 1
}

but in the database the values don't change

this my lambda script

script in gist github

edited Jan 18 '21 at 12:06

herve

3,825
2
18
27

asked Mar 06 '19 at 09:04

Aminudin

i am unfamiliar with nodejs and mysql, but have you set transaction mode? are you missing a commit maybe= – JoSSte Mar 06 '19 at 09:12
don't post code as link .. post text code .. in your question – ScaisEdge Mar 06 '19 at 09:24
3

have you found a solution? I am in the same situation – user299791 Feb 24 '20 at 08:41

Updating MySQL returns rows affected, but doesn't actually update the Database [ nodejs mysql2 ]

0 Answers0