mysql如何批量insert数据

//设置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);

  }

}