tp5模型删查和聚合

$user = User::get(1);
$user->delete();
或者通过数据库类的查询条件删除
User::where(‘id‘,‘>‘,10)->delete();

取出主键为1的数据
$user = User::get(1);
echo $user->name;
或者在实例化模型后调用查询方法
$user = new User();// 查询单个数据
$user->where(‘name‘, ‘thinkphp‘)
    ->find();
在实例化模型后调用查询方法
$user = new User();// 查询数据集
$user->where(‘name‘, ‘thinkphp‘)
    ->limit(10)
    ->order(‘id‘, ‘desc‘)
    ->select();

$user = new User;
$user->count();
$user->where(‘status‘,‘>‘,0)->count();
$user->where(‘status‘,1)->avg(‘score‘);
$user->max(‘score‘);