把两张表导出csv,然后用vlookup来合并,下拉自动填充后一直是重复值
代码: 全选
=VLOOKUP(A1,H1:I1021,2)
代码: 全选
=VLOOKUP(A1,H1:I1021,2)
代码: 全选
=VLOOKUP(A2,$H$1:$I$765,2, )
代码: 全选
UPDATE `pre_app_rzlx_rk`,`pre_app_zflx_rk` SET `pre_app_rzlx_rk`.`No` = `pre_app_zflx_rk`.`No` WHERE `pre_app_rzlx_rk`.`uid` =`pre_app_zflx_rk`.`uid` AND (`pre_app_rzlx_rk`.`title_now` LIKE '7__')
代码: 全选
$query = DB::query("SELECT * FROM ".DB::table('app_rzlx_rk')." WHERE `No` AND `time_now`>" .$tmptime." AND `title_now` LIKE '7__' ORDER by `score_avg` DESC, `time_now` DESC LIMIT $start_limit, 20");