数据库增删改操作

        一、增加操作

1、插入单条数据

// 数组中的字段名 必须和数据库中的字段名一致

$data=["name"=>"张三","pass"=>"123","age"=>18,];

$code=Db::table("user")->insert($data);

$code=db("user")->insert($data);
// INSERT INTO `user` (`name` , `pass` , `age`) VALUES ('张三' , '123' , 18)
// 返回值 影响行数

2、插入多条数据

$data=[
["name"=>"张三1","pass"=>"123","age"=>15,],
["name"=>"张三2","pass"=>"123","age"=>19,],
];

$code=Db::table("user")->insertAll($data);
$code=db("user")->insertAll($data);
// 返回值 影响行数

3、获取最后一次插入ID

$data=["name"=>"张三","pass"=>"123","age"=>18,];
$code=Db::table("user")->insertGetId($data);
$code=db("user")->inserGetId($data);

// 返回值最后插入的id

        二、更新数据

1、修改数据

$code=Db::table("user")->where("id",">",'60')->update(["pass"=>"qwe","age"=>2]);
// UPDATE `user` SET `pass`='qwe',`age`=2 WHERE `id` > 60
// 返回值 影响行数 

$code=Db::table("user")->update(['age'=>52,"id"=>62]);
// UPDATE `user` SET `age`=52 WHERE `id` = 62

$code=Db::table("user")->where("id",73)->setField("pass",'abc');
// UPDATE `user` SET `pass`='abc' WHERE `id` = 73

2、设置自增

$code=Db::table("user")->where("id",63)->setInc("age");
// UPDATE `user` SET `age`=age+1 WHERE `id` = 63

$code=db("user")->where("id",66)->setInc("age");
// UPDATE `user` SET `age`=age+1 WHERE `id` = 66

3、设置自减
// UPDATE `user` SET `age`=age-1 WHERE `id` = 62
$code=Db::table("user")->where("id",62)->setDec("age");

$code=Db::table("user")->where("id",62)->setDec("age",3);
// UPDATE `user` SET `age`=age-3 WHERE `id` = 62

$code=db("user")->where("id",63)->setDec("age",3);
// UPDATE `user` SET `age`=age-3 WHERE `id` = 63

        四、删除数据

1、删除一条数据

$code=Db::table("user")->where("id","71")->delete();

$code=Db::table("user")->delete(70);

2、删除多条数据

$code=Db::table("user")->where("id in(51,54,55)")->delete();

$code=Db::table("user")->delete([62,63,66]);


3、删除区间数据

$code=Db::table("user")->where("id>40 and id<45")->delete();

// DELETE FROM `user` WHERE ( id>40 and id<45 )