async function changePw(id: string, hash: string) {
try {
const [result] = await pool.execute('UPDATE User SET password_hash = ? WHERE id = ?',
[
hash,
id
])
const resObj = JSON.parse(JSON.stringify(result))
if( resObj.affectedRows ) return 'success'
else return 'fail'
} catch (e) {
console.log('userCalls.changePw error', e)
}
}
https://sidorares.github.io/node-mysql2/docs/examples/queries/simple-queries/update#querysql