MYSQL数据库删除操作关于Node.js

1.举例子删除主键:id=6的一列数据

2.代码过程

var mysql = require('mysql'); 
var connection = mysql.createConnection({ host : 'localhost', user : 'root', password : '123456', port: '3306', database: 'test' }); 
    connection.connect(); 
var delSql = 'DELETE FROM websites where id=6'; 
//删 connection.query(delSql,function (err, result) { 
if(err){ 
    console.log('[DELETE ERROR] - ',err.message); 
    return; 
} 
console.log('--------------------------DELETE----------------------------'); console.log('DELETE affectedRows',result.affectedRows); 
console.log('-----------------------------------------------------------------\n\n'); }); 
connection.end();

3.结果输出

--------------------------DELETE----------------------------
                DELETE affectedRows 1 
-----------------------------------------------------------------