php - LOAD DATA LOCAL INFILE 只进入5行

Question

我有一个 csv 文件，我正在使用 LOAD DATA LOCAL INFILE命令将其加载到 mysql 中，但我不知道为什么它只读取其中的 5 行。这是我的 php 代码:

<?php
include "../config.php";
$conn = new mysqli( $servername, $username, $password, $dbname );
if ( $conn->connect_error ) {
    die( "Connection failed: " . $conn->connect_error );
} //$conn->connect_error

$sql= "LOAD DATA LOCAL INFILE 'uploads/cell.csv'
INTO TABLE table3
CHARACTER SET UTF8
FIELDS TERMINATED BY ','
LINES TERMINATED BY '\r\n'";
$result           = $conn->query( $sql );
echo("Error description: " . mysqli_error($conn));
?>

并且 csv 文件附在下面的链接中。

cell.csv

执行php代码后Mysql如下所示:

Answer 1

我终于自己弄清楚了，问题是/r/n，有些行以/r结尾，有些以/r/n结尾，我将代码改为:

<?php
include "../config.php";
$conn = new mysqli( $servername, $username, $password, $dbname );
if ( $conn->connect_error ) {
    die( "Connection failed: " . $conn->connect_error );
} //$conn->connect_error

$sql= "LOAD DATA LOCAL INFILE 'uploads/cell.csv'
INTO TABLE table3
CHARACTER SET UTF8
FIELDS TERMINATED BY ','
LINES TERMINATED BY '\r'";
$result           = $conn->query( $sql );
echo("Error description: " . mysqli_error($conn));
?>

它解决了问题。