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

0 vote176 views1 answer
How to get data from 2 database
SQL
1 vote205 views2 answers
Job for mysql.service failed because the control process exited with error code. see "systemctl status mysql.service" and "journalctl -xe" for details.
SQL
1 vote147 views1 answer
Duplicating a MySQL table with all the data Command
SQL
2 votes169 views1 answer
Mysql cannot delete or update a parent row
SQL
0 vote164 views1 answer
Mysqli_connect using prepare statement
SQL
0 vote166 views1 answer
Like date sql server not working
SQL
0 vote140 views1 answer
Postgresql create user roles
SQL
-1 vote149 views3 answers
Create temp table in sql
SQL
0 vote113 views2 answers
Https://www.google.com/search?ei=bihqX_v9DJb--gTYoLH4DQ
SQL
0 vote149 views1 answer
Sql database connectivity
SQL