關于node.js操作mysql數據庫的相關介紹請閱讀全文吧。下文介紹的非常詳細，具體內容如下所示：

安裝mysql模塊

npm install mysql

數據庫準備

mysql server所在的機器IP地址是192.168.0.108，登錄賬戶就用root@123456

在mysql中創建test數據庫

在test數據庫中創建一張users表

操作

連接數據庫

var mysql=require('mysql');

var connection = mysql.createConnection({

host : '192.168.0.108',user : 'root',password : '123456',database : 'test1',port:'3306'

});

connection.connect();

插入一個user

var usr={name:'zhangsan',password:'pwdzhangsan',mail:'zhangsan@gmail.com'};

connection.query('insert into users set ?',usr,function(err,result) {

if (err) throw err;

console.log('inserted zhangsan');

console.log(result);

console.log('\n');

});

更新user，帶條件

connection.query('update users set password="ddd" where name="zhangsan"',{password:'ppp'},result) {

if (err) throw err;

console.log('updated zhangsan\'s password to ddd');

console.log(result);

console.log('\n');

});

刪除一個user，帶條件

connection.query('delete from users where name="zhangsan"',result) {

if (err) throw err;

console.log('deleted zhangsan');

console.log(result);

console.log('\n');

});

查詢user，所有

connection.query('select * from users',rows,fields) {

if (err) throw err;

console.log('selected after deleted');

for(var i= 0,usr;usr=rows[i++];){

console.log('user nae='+usr.name + ',password='+usr.password);

}

console.log('\n');

});

關閉數據庫連接

connection.end();

基本的CRUD完成

mysql模塊的完整功能說明參見官方：

全部demo代碼

var mysql=require('mysql');

var connection = mysql.createConnection({

host : '192.168.0.108',port:'3306'

});

connection.connect();

var usr={name:'zhangsan',result) {

if (err) throw err;

console.log('inserted zhangsan');

console.log(result);

console.log('\n');

});

connection.query('select * from users',fields) {

if (err) throw err;

console.log('selected after inserted');

for(var i= 0,password='+usr.password);

}

console.log('\n');

});

connection.query('update users set password="ddd" where name="zhangsan"',result) {

if (err) throw err;

console.log('updated zhangsan\'s password to ddd');

console.log(result);

console.log('\n');

});

connection.query('select * from users',fields) {

if (err) throw err;

console.log('selected after updated');

for(var i= 0,password='+usr.password);

}

console.log('\n');

});

connection.query('delete from users where name="zhangsan"',result) {

if (err) throw err;

console.log('deleted zhangsan');

console.log(result);

console.log('\n');

});

connection.query('select * from users',password='+usr.password);

}

console.log('\n');

});

connection.end();