Resullt all update knex mysql

const {id,name} = req.body;
    const subQuery = knex('client').select('id').where({id})
    subQuery.then(response=>{
    if(response.length>0){
        subQuery.update({name})
        .then(resp=>{
            res.json('update done')
        })
        .catch(err=>{res.json(err)})
    }
    else{
        res.json('update failed')
     }
})
.catch(err=>{res.json(err)})

Source: stackoverflow.com

Similar codes

59 votes7.7K views6 answers
Alter table sql
SQL
12 votes176 views1 answer
Docker mysql random root password
SQL
0 vote195 views1 answer
To Create directory
SQL
2 votes174 views6 answers
Mysql change timezone
SQL
8 votes176 views2 answers
Alert table name mysql
SQL
11 votes224 views2 answers
Docker create postgres db
SQL
4 votes167 views1 answer
Mysql copy table with new name
SQL
0 vote186 views1 answer
List all permissions on a table in postgres
SQL
1 vote177 views1 answer
Find a column in all tables postgres
SQL
0 vote223 views1 answer
Updating database in sql
SQL