本文详细介绍了使用SQL进行数据查询的各种技巧，包括字段选择、排序、分页、分组及连接操作等。通过实例展示了如何高效地从数据库中获取所需信息。
$data =$user->field('name as uname')->select();
$data = $user->order('id desc')->select();
$data = $user->order('id ')->limit(5)->select();
$data = $user->page('1,10')->select();
$data = $user->group('active')->select();
$data = $user->group('active')->having('active=1')->select();
$data = $user->join('A on user.id=A.id')->select();
$data = $user->join('inner join A on user.id=A.id')->select();
$data = $user->join('right join A on user.id=A.id')->select();
$data = lock(true)->select();
$data = $user->order('id desc')->select();
$data = $user->order('id ')->limit(5)->select();
$data = $user->page('1,10')->select();
$data = $user->group('active')->select();
$data = $user->group('active')->having('active=1')->select();
$data = $user->join('A on user.id=A.id')->select();
$data = $user->join('inner join A on user.id=A.id')->select();
$data = $user->join('right join A on user.id=A.id')->select();
$data = lock(true)->select();
扫一扫
730
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
