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 vote205 views1 answer
Load data from text file to mysql database on mac terminal
SQL
0 vote200 views1 answer
Php mysqli install
SQL
3 votes191 views2 answers
Sql server current date without time
SQL
0 vote208 views1 answer
Best practive to pass multiple table to stored procedure in sql server
SQL
3 votes341 views2 answers
Oracle sql first day of month
SQL
9 votes214 views2 answers
Convert data type in sql
SQL
4 votes1.1K views2 answers
Host '192.168.43.100' is not allowed to connect to this MySQL server
SQL
0 vote205 views2 answers
Oracle select
SQL
0 vote215 views1 answer
Sql query to find duplicate email address
SQL
6 votes213 views2 answers
Postgresql pg_dump
SQL