随便写的sql语句

sql 语句

SELECT * FROM `user`  查询表 

SELECT * FROM class

SELECT u_name FROM `user` 字段查询

SELECT * FROM user ORDER BY u_age DESC  根据字段倒序

SELECT * FROM user  WHERE ( u_age > 2)    查询2以上的数据

SELECT * from user left join class on user.b_id=class.b_id  两表联查


SELECT * from user as U LEFT JOIN class  as  C on U.b_id = C.b_id  ORDER BY U.u_id  两表联查 并且主表id段倒序

tp5框架 俩表联查

 $map = [];
	    if($search) {
	        $map['a.title']=['like','%'.$search.'%'];
	    }
 $res = Db::table('aoly_category')->alias('c')
	           ->field('c.id as cid,siteid,c.title as ctitle,pid,sid,tdk_key,a.*')
	           ->join('aoly_article a','c.id = a.catid')
	           ->where($map)
	           ->where('a.status','<>',2)
	           ->order('a.inputtime desc')
		       ->select();
-------------------------------------------------------------------
$res = Db::table('aoly_category')->alias('c')
	            ->field('c.id as cid,siteid,c.title,pid,sid,tdk_key,a.*')
	            ->join('aoly_article a','c.id = a.catid')
	            ->where('a.title','like','%'."$search".'%')
	            ->where('a.status','<>',2)
	            ->order('a.inputtime desc')
	            ->select();