一、基本的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!');
}
})