nodeJS中的数据删除问题

Question

我与sql服务器的连接已经完成。但是delete查询没有执行，并且在“连接已成功完成”上有一个卡住--我的代码如下所示

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');
        }
    });
}

数据库表

Answer 1

在deletedata函数中有一个错误

=它不是将值赋值给con.query，而是函数调用

函数应该看起来像

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');
        }
    });
}