查询
select
SELECT * FROM `feedback` WHERE 1;
指定列查询
SELECT `msg`,`name` FROM `feedback` WHERE 1;
select * from feedback where name='小曾';
添加查询条件
select * from feedback where msg like '%山%'
查询msg中包含山的元素
%代表是任意字符
select * from feedback where msg like '山_有%'
_代表任意一个字符串
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.createConnect({
host:"localhost",
user:"root",
password:"",
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){
console.log(result)
}
})
7. 断开数据库
conn.end(function(){
console.log("数据库已断开")
})