MYSQL创建临时表

		$time = time();
        echo "插入时间".date('Y-m-d H:i:s',$time)."<br />";

        $sql= "create temporary table xmn_zhuyk_linshi (
                        id int(11) unsigned not null auto_increment,
                        user_id int(50) not null,
                        create_time int (11),
                        PRIMARY KEY (`id`))";
        
        $affected = Db::execute($sql);

        if(!$affected){
            echo "建表时间".date('Y-m-d H:i:s',time())."<br />";

            for($i=1;$i<100000;$i++){
                $data[] = [
                    'user_id'=>$i,
                    'create_time'=>$time
                ];
                if(count($data)>1000){
                    Db::name('zhuyk_linshi')->insertAll($data);
                    $data = [];
                }
            }

            echo "结束时间".date('Y-m-d H:i:s',time())."<br />";

            $list = DB::name('zhuyk_linshi')->limit(10)->select();
            print_r($list);

        }else{
            echo "建表失败";
        }