Data delete issue with nodeJS

Meshkat Rangon 0
Viewed 15

My connection to the sql server was done. but the delete query is not executing and having a stuck at "connection was done successfully" my code is given below

var mysql = require('mysql');
var dbconnect = {
    host: 'localhost',
    user: 'root',
    pass: '',
    database: 'school'
}

var con = mysql.createConnection(dbconnect);
con.connect(function (error) {
    if (error) {
        console.log('connection failed');
    } else {
        console.log('connection done');
        deletedata(con);
    }

});

function deletedata(con) {
    let sqlquery = "DELETE * FROM `std_list` WHERE name='meshkat'";
    con.query=(sqlquery, function (error) {
        if (error) {
            console.log("data delete fail");
        } else {
            console.log('data delete done');
        }
    });
}

database table

javascript
1 Answers

you have a typo in the deletedata function

delte = it is not assign value into con.query but function call

function should look like

function deletedata(con) {
    let sqlquery = "DELETE * FROM `std_list` WHERE name='meshkat'";
    con.query(sqlquery, function (error) {
        if (error) {
            console.log("data delete fail");
        } else {
            console.log('data delete done');
        }
    });
}
Michal Miky Jankovský0
Related