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 vote322 views1 answer
Sqlite update where exists
SQL
18 votes329 views6 answers
Drop table if exists
SQL
2 votes335 views1 answer
Sql OR
SQL
2 votes341 views1 answer
SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost' (SQL: select * from information_schema.tables where table_schema = whatsapp and table_name = migrations and table_type = 'BASE TABLE')
SQL
13 votes332 views4 answers
Command line mysql import
SQL
-1 vote291 views1 answer
Plsql while
SQL
9 votes311 views3 answers
Where in sql
SQL
0 vote322 views2 answers
Mysql select date from datetime
SQL
0 vote358 views1 answer
Database schema for mcqs type exam in sql
SQL
0 vote333 views1 answer
Sql server create constraint
SQL