Need help to write mysql update query in node.js with callback

Question

I am a beginner for Node.js. Please help to fix this.

Without giving WHERE clause update is working fine. Below is the script without "WHERE" clause:

var post  = {name: 'Amit', mobile:'123456'};
var query = connection.query('UPDATE contacts SET ? ', post , function(err, result) {});
console.log(query.sql);

Output:

enter image description here

Now I added 'WHERE' clause..getting error:

var post  = {name: 'Amit', mobile:'123456'};
var condition = {id:4};
var query = connection.query('UPDATE contacts SET ? ',post,' WHERE '+ condition , function(err, result) {});
console.log(query.sql);

Output:

enter image description here

Try change 'WHERE '+condition with 'WHERE id='+condition.id

David Miró
– David Miró

2013-05-08 09:37:37 +00:00
Commented May 8, 2013 at 9:37 — David Miró
– David Miró, Commented May 8, 2013 at 9:37

ltebean · Accepted Answer · 2013-05-08 08:52:40Z

3

According to the api, your should write you query like this:

connection.query('UPDATE contacts SET Name = ?,Mobile=? WHERE yourCondition = ?', [post.name,post.mobile,condition], function(err, result) {})

answered May 8, 2013 at 8:52

ltebean

1,0176 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Cesk · Accepted Answer · 2015-11-16 12:25:02Z

1

Try that code:

var post  = {name: 'Amit', mobile:'123456'};
var condition = {id:4};
var query = connection.query('UPDATE contacts SET ? WHERE ?', [post, condition] , function(err, result) {});
console.log(query.sql);

answered Nov 16, 2015 at 12:25

Cesk

111 bronze badge

Comments

Rob Wilkerson · Accepted Answer · 2014-03-17 23:38:23Z

0

try this ,it workd for me

connection.query('UPDATE nodeDB.USER SET USER_PASSWORD :Pass WHERE USER_NAME :Name',
  {Name: 'max',Pass: '123'}, function(err, rows) {
});

edited Mar 17, 2014 at 23:38

Rob Wilkerson

41.4k44 gold badges140 silver badges194 bronze badges

answered Feb 11, 2014 at 5:50

pitu

8203 gold badges14 silver badges35 bronze badges

Comments

vinod gami · Accepted Answer · 2017-12-04 11:46:30Z

Check My code also work for you.

router.all('/setLoginDetails', function (req, res) {
    if(req.method == 'POST')
    {
        var Req = req.body;
    }
    else
    {
        var Req = req.query;
    }
    if(Req.lang == undefined || Req.lang == 'en')
    {
        const message = require('../lang/messages_en.json');
    }

    if(Req.id == undefined || Req.id == '')
    {
        return res.json({"success" : false, "Message" : message.REQUIRED , "data" : {} });
    }

    qb.select('id')
        .where({id: Req.id})
        .get('table', (err,rows) => {
            if (err || rows.length == 0)
            {

                return res.json({"success" : false, "Message" : "No data found", "data" : Response});
            }
            else
            {
                _.each(rows, function(record) {
                    var token = tokenGenerate();
                    qb.update('token', {token: token}, {driver_id:record.id}, (err, result) => {
                        if (err) return console.error(err);
                    });

                    qb.select('*').where({driver_id: record.id}).get(model.DriverLogin, (err,rows) => {
                        var lat = Req.lat;
                        var lng = Req.lng;
                        if(Req.lat == '')
                        {
                            lat = 0.0;
                        }
                        if(Req.lng == '')
                        {
                            lng = 0.0;
                        }
                        var updateData = {lat : lat ,lng : lng, status : 'free', screen : Req.device_info, driver_id : record.id};
                        if(rows.length > 0)
                        {
                            qb.update('localtion', updateData, {driver_id:record.id}, (err, result) => {
                                if (err) return console.error(err);
                            });
                        }
                        else
                        {
                            qb.insert(model.DriverLogin, updateData, (err, res) => {
                                if (err) return console.error(err);
                            });
                        }
                    });
                });

                return res.json({"success" : true, "Message" : "Data Updated", "data" : Response});
            }
        }
    );
});

Collectives™ on Stack Overflow

Need help to write mysql update query in node.js with callback

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related