批量插入数据insert into select示例

 

//增加
                        $addSql =" insert into hxqc_auth_group_limits(group_id,company_id)";
                        foreach ($add_data as $val) {
                            $addSql .=" select '$k','$val' union all";
                        }
                        if(strrpos($addSql, 'union all', -1)===strlen($addSql)-9){
                            $addSql = rtrim($addSql,'union all');
                            $insertAffect = M()->execute($addSql);
                            if($insertAffect === false) {
                                $this->rollback();
                                return 1;
                            }
                        }