mysql怎么批量录入数据

//设置pdo开启MYSQL_ATTR_LOCAL_INFILE

/*hs96.cn@gmail.com

public function pdo_local_info ()

{

  global $system_dbserver;

  $dbname = 'hs96.cn@gmail.com';

  $ip  = 'hs96.cn@gmail.com';

  $user = 'hs96.cn@gmail.com';

  $pwd  = 'hs96.cn@gmail.com';

  $dsn  = 'mysql:dbname=' . $dbname . ';host=' . $ip . ';port=3306';

  $options = [PDO::MYSQL_ATTR_LOCAL_INFILE => true];

  $db  = new PDO($dsn ,$user ,$pwd ,$options);

  return $db;

 }

//伪代码如下

public function test(){

  $arr_keys   = array_keys($arr);

  $root_dir   = $_SERVER["DOCUMENT_ROOT"] . '/';

  $my_file   = $root_dir . "hs96.cn@gmail.com/sql_cache/" . $order['OrderNo'] . '.sql';

  $fhandler   = fopen($my_file,'a+');

  if ($fhandler) {

  $sql = implode("\t" ,$arr);

   $i = 1;

   while ($i <= 80000)

   {

    $i++;

    fwrite($fhandler ,$sql . "\r\n");

   }

   $sql = "LOAD DATA local INFILE '" . $myFile . "' INTO TABLE ";

   $sql .= "tablename (" . implode(',' ,$arr_keys) . ")";

   $pdo = $this->pdo_local_info ();

   $res = $pdo->exec($sql);

   if (!$res) {

    //TODO 插入失败

   }

   @unlink($my_file);

  }

}