【数据删除及执行原生sql语句】

delete() 返回受影响的记录条数

$goods -> delete(30); 删除主键值等于30的记录信息

$goods -> delete(“10,12,13”); 删除主键值等于10 12 13的三条记录

$goods -> where(“goods_id>60”)->delete() 把符合条件的记录都给删除

$goods = D(“Goods”);

$sql = “select * from sw_goods”;

$rst = $goods -> query($sql);

$sql = “select goods_category_id,avg(goods_price) from sw_goods group by goods_category_id having avg(goods_price)>1000”;

$goods -> query($sql);

$sql = “update sw_goods set goods_name = ‘htc_two’ where goods_id=100”;

$goods -> execute($sql);

巴特西