knex增删改查

转载，原文链接https://blog.csdn.net/qq_24134853/article/details/81707611

 固定公式

knex(‘表名’).where().方法()

 查询

knex('student')
.where({name:'小明',age:16})
.select()

//对应的SQL
select * from student where name='小明' and age=16;

 新增

knex('student')
.insert({name:'小强',age:20})
//对应的SQL
insert into student ("name","age") values ("小强",20)

修改

knex('student')
.where('age','<',18)
.update({
    age: 18
})
//对应的SQL
update student set age=18 where age<18;

删除

knex('student')
.where('name','小明')
del()
//对应的SQL
delete from student where name='小明'

where 的三种写法

where(对象)
where(key,value) //键值对
where(key,操作符，value)