[Node.js] MySql CRUD

var sql = 'SELECT * FROM topic';

conn.query(sql, function(err, rows, fiedls){

if(err){

console.log(err);

}else{

for(var i=0; i<rows.length; i++){

console.log(rows[i].author);

}

}

});

conn.end();

[INSERT]

var sql = 'INSERT INTO TOPIC(title, description, author) VALUES(?,?,?)';

var params = ['SuperVisor','Watcher','graphittie'];

conn.query(sql,params, function(err,rows, fields){

if(err){

console.log(err);

}else{

console.log(rows.insertId);

}

})

conn.end();

 

[UPDATE]

var sql = 'UPDATE topic SET title=?, author=? where id=?';

var params = ['NPM','leezche',1];

conn.query(sql,params, function(err,rows, fields){

if(err){

console.log(err);

}else{

console.log(rows);

}

})

conn.end();

 

[DELETE]

var sql = 'DELETE FROM topic WHERE id=?'

var params = [7];

conn.query(sql,params, function(err,rows, fields){

if(err){

console.log(err);

}else{

console.log(rows);

}

})

conn.end();