mysql - phpmyadmin打开一张数据较多的表（1W条）出现内存溢出情况

Question

Answer 1

把php.ini超时时间调大一点就行了

max_execution_time = 

Answer 2

/*
    function changeCustomerOwnerRoleId(){
        set_time_limit(360);
        ini_set('memory_limit', '1024M');
        require_once "connect.php";
        $role = getRole();
        $belong_user = getBelonguser();
        foreach ($belong_user as $bk=>$bv){
            foreach ($role as $rk => $rv){
              if ($bv['belong_user'] == $rv['name']){
                $sql = "update gs_customer set owner_role_id = '{$rv['role_id']}' where gs_customer.belong_user ='{{$rv['name']}}'";
                mysqli_query($connect,$sql);
                }
            }
        }
    }*/

我是执行了这个语句之后出现的，其他表40W数据打开都没问题

Answer 3

sql语句的引号有问题

$sql = "update gs_customer set owner_role_id = '{".$rv['role_id']."}' 
where gs_customer.belong_user = '{".$rv['name']."}'";