mysql总结笔记

1."select id,title,image_url,type,type_id ,click_url from home_banner where area like '%".$area."%'  or area = '' ";
//注意这个是=不是==；
2，"select version from update_version where  id = (select max(id) from update_version)";
3，"select id,title,image_url,type from news where type = '".$type."'and (area like '%".$area."%'  or area = '') and is_banner = 1";
4.在MySQL中是可以直接用〈的
5.$list=$mo->table(array('think_mvc'=>'mvc','think_test'=>'test'))->where('mvc.name="aaaa" and test.id=1')->field('mvc.name as n,test.sex as s')->select();
或者table('bm_member m,bm_company c')