mysql句子-常用整理

<?PHP

//**********************原生mysql语句**********************

CAST(IF(b.share is null,0,b.share)/a.share as DECIMAL(10,2)) as jindu

FROM_UNIXTIME(a.add_time) as create_time

$sql ="select a.id as aatpbe_id,a.save_type,a.name from (select id,save_type,aatpb_id,name,content,sort from think_aatp_b_e order by sort desc ) as a ";
$sql.=" join (select id,atp_id from think_aatp_b where is_delete=0 and type=1 and atp_id=".$atp_id.") as b on b.id=a.aatpb_id";
$plant_cp=Db::query($sql);


//**********************tp5 sql语句**********************

//子查询
$subQuery = Db::table('think_user')->field('id,name')->where('id','>',10)->buildSql();

CAST(IF(b.share is null,0,b.share)/a.share as DECIMAL(10,2)) as jindu

FROM_UNIXTIME(a.add_time) as create_time

//获取最后一个自增的ID
$id=Db::name('user')->insertGetId($data);

$id = Db::name('user')->getLastInsID();

$data = [
    ['foo' => 'bar', 'bar' => 'foo'],
    ['foo' => 'bar1', 'bar' => 'foo1'],
    ['foo' => 'bar2', 'bar' => 'foo2']
];
Db::name('user')->insertAll($data);

//tp5的打印最后一条sql
Db::table('member_certification')->getLastSql();
$ddddd=Db::table('member_certification')->getLastSql();
print_r($ddddd);
exit();
Db::name('report')->fetchSql(true)->insert($report)强制打印
Db::name('report')->fetchSql(true)->insert($report)强制打印