原文鏈接
node連接mysql
mysql安裝
mysql基本命令
修改root密碼123為1234
mysqladmin -u root -p 123 password 1234;
顯示數(shù)據(jù)庫
show databases;
創(chuàng)建數(shù)據(jù)庫腿倚，例如：create database database_test
create database [database];
使用數(shù)據(jù)庫,例如：use database_test
use [database];
刪除數(shù)據(jù)庫兄朋，例如：drop database database_test
drop database [database];
創(chuàng)建表，例如：create table_test(name char(10) not null,age int(4))
create table <table>(<field><type>);
插入數(shù)據(jù)央渣，例如：insert into table_test (name,age) values ('vist',24)
insert into <table>(<field>) values (<value>);
查詢數(shù)據(jù)喷好，例如：select * from table_test
select * from <table>;
修改數(shù)據(jù)，例如：update table_test set age=18 where name='vist'
update <table> set <fidld>=<value> where <if>;
刪除數(shù)據(jù)，例如：delete from table_test where name='vist'
delete from <table> where <if>;
node配置
需要安裝mysql包
npm install mysql
node連接數(shù)據(jù)庫
var mysql=require('mysql');
var database='database_test';
var table='table_test';
配置用戶密碼
var client=mysql.createConnection({
user: 'root',
passowrd: '1234'
});
連接數(shù)據(jù)庫
client.connect();
console.log('連接數(shù)據(jù)庫');
使用數(shù)據(jù)庫
client.query('use '+ database);
查詢操作
client.query('select * from '+ table , function(err, results, fields){
if(err){
throw err;
}
if(results){
console.log('查詢');
results.map(function(item){
console.log('%s\t%d', item.name, item.age);
})
}
});
插入操作
client.query('insert into '+ table + '(name, age) values (?, ?)', ['bestvist',20], function(err, results, fields){
if(err){
throw err;
}
if(results){
console.log('插入');
console.log(results);
}
});
更新操作
client.query('update '+ table + ' set age=? where name=?',[18, 'bestvist'],function(err, results, fields){
if(err){
throw err;
}
if(results){
console.log('更新');
console.log(results);
}
});
刪除操作
client.query('delete from '+ table +' where name=?', ['bestvist'], function(err, results, fields){
if(err){
throw err;
}
if(results){
console.log('刪除')围橡；
console.log(results);
}
})
關(guān)閉數(shù)據(jù)庫
client.end();