首先连接MySQL数据库:
我是写好连接方式,哪里用到哪里调用,这样方便,比如我的connectdb.js:
var mysql = require('mysql');
function connectdb(){
var connection = mysql.createConnection({
host : 'localhost',
port : '3306',
user : 'root',
password : '',
database : 'myfirst'
});
return connection;
};
module.exports=connectdb;
node查询mysql数据:
引用的require(‘./connectdb’)就是上面的连接数据库的脚本。
var conn = require('./connectdb');
var connection=conn();
var sql_select = "select * from user";
connection.query(sql_select,function (err, result) {
if(err){
console.log('[SELECT ERROR] - ',err.message);
return;
}
var string=JSON.stringify(result);
var data = JSON.parse(string)
console.log(string);
});
connection.end();
node增加(插入)MySQL数据:
var conn = require('./connectdb');
var connection=conn();
var addUser = "INSERT INTO user SET ?";
connection.query(addUser,response,function (err, result) {
if(err){
console.log('[SELECT ERROR] - ',err.message);
return;
}
var string=JSON.stringify(result);
var data = JSON.parse(string)
console.log(string);
});
node修改MySQL数据:
node对MySQL数据的操作只有SQL语句不同,其它都一样
connection.query('UPDATE user SET foo = ?, bar = ?, baz = ? WHERE id = ?', ['a', 'b', 'c', userId], function (error, results, fields) {
if (error) throw error;
// ...
});
node删除MySQL数据:
connection.query('DELETE FROM posts WHERE title = "wrong"', function (error, results, fields) {
if (error) throw error;
console.log('deleted ' + results.affectedRows + ' rows');
})
在这里留下官方的api:
mysql模块的完整功能说明参见官方: