SQL LOCAL INFILE

Here we export large CSV data into the SQL table using LOCAL INFILE.

Example

First of all, create a SQL table where you want to import CSV data. The SQL table column number needs to same as the CSV column.

if the MYSQLI_OPT_LOCAL_INFILE is false so use mysqli_options($conn, MYSQLI_OPT_LOCAL_INFILE, true).


<?php

// if MYSQLI_OPT_LOCAL_INFILE is false

mysqli_options($conn, MYSQLI_OPT_LOCAL_INFILE, true);

$file = 'CsvFile.csv';

$table = 'SqlTable';

$sql = "LOAD DATA LOCAL INFILE '$file' 

        INTO TABLE $table 

        FIELDS TERMINATED BY ',' 

        ENCLOSED BY '".'"'."' 

        LINES TERMINATED BY '\n' 

        IGNORE 1 LINES"; 

mysqli_query($conn, $sql);

?>

Share