node连接mysql

 

一、基本的mysql操作命令

在mysql client 下输入账号密码登录，执行下面命令。

 

show databases; // 查看所有数据库

 

create database user ; //创建数据库 user

 

use user ; // 使用 user 数据库

 

// 创建 admin表

create table admin(

id int not null primary keyauto_increment,

username varchar(255) not null,

password varchar(255) not null

);

 

// 创建 info表

create table info(

id int not null primary keyauto_increment,

username varchar(50) not null ,

likes varchar(255),

content varchar(255)

);

 

// admin表中插入数据

insert into admin (username,password)values ("wenqing","mmd");

insert into admin (username,password)values ("wenruo","kkd");

insert into admin (username,password)values ("pengzhan","ssd");

insert into admin (username,password)values ("liming","wwd");

insert into admin (username,password)values ("jack","jjd");

 

// info 表中插入数据

insert into info(username,likes,content) values ( "wenqing", "eat","iam not fat");

insert into info(username,likes,content) values ( "wenruo", "sing","iam very handsome");

insert into info(username,likes,content) values ( "pengzhan","programming","it is not hard");

insert into info(username,likes,content) values ( "liming", "sleep","iwant buy some things");

insert into info(username,likes,content) values ( "jack","shopping","do not bother me ,zz~");

 

// 修改info 表中数据

update info set content='i am reallyhandsome' where username = 'wenruo';

 

// 查看admin表信息

desc admin;

 

// 查找admin表中所有数据

select * from admin;

 

 

二、nodejs连接操作mysql  

 

配置必要的依赖：

 

npm  install mysql  --save-dev

 

新建js文件 ，内容如下 ：

 

var mysql=require('mysql');

var connection = mysql.createConnection({// 配置必要的连接信息

host:'localhost',

user:'root',

password:'your pass word',

database:'user',  // 想要连接的数据库名称

port:'3306'  // 根据自己端口，默认3306

})

 

connection.connect(function (err) { //连接数据库

if(err)

{

console.log('connect database failed');

}

else{

console.log('connect success!');

}

})

 

var SqlString ='select * from admin';

connection.query(SqlString,function(err,result) {  // 执行sql语句，返回执行结果

if(err)

{

console.log('query error');

}

else

{

console.log(result);

}

})

 

connection.end(function (err) {

if(err){

console.log('close database error');

}

else

{

console.log('close database success!');

}

})