package.json->script
"serve":"node main.js"
npm run serve
cmd
进入项目目录
node main/js
mysql命令
查询 select
SELECT * FROM `feedback` WHERE 1;
查询全部
SELECT msg,name FROM `feedback` WHERE 1;
指定列查询
SELECT * FROM `feedback` WHERE NAME='lyw';
添加查询条件
SELECT * FROM `feedback` WHERE msg like '%h%';
查询msg中包含h的元素
%表示任意字符
SELECT * FROM `feedback` WHERE msg like 'h_%';
_代表任意字符
SELECT * FROM `feedback` WHERE 1 order by `datetime` DESC;
按时间排序 降序
SELECT * FROM `feedback` WHERE 1 order by `datetime` DESC limit 2,3;
查询偏移2个 截取3行
增加 insert into
修改 update
删除 delete
node操作sql
1.安装
npm i mysql -S
2.导入
const mysql=require(“mysql”)
3.创建连接
const conn = mysql.createConnection({
host: "localhost",
user: "root",
password: "123456",
database: "feed"
})
4.连接数据库
conn.connect(function (err) {
if (!err) {
console.log("数据库连接成功");
}
})
5.定义sql
var sql = "select * from feedback where 1";
6.执行sql
conn.query(sql, function (err, result) {
if (!err) {
//res就是从数据库获取的数据
// console.log(res);
res.end(JSON.stringify(result))
} else {
// console.log(err);
res.end(`{"code":1,"msg":"数据库错误"}`)
}
})
7.断开数据库
conn.end(function (err) {
if (!err) {
console.log("数据库已经断开");
}
})