How can you use LOAD DATA INFILE to import only specific columns from a tab-separated file in PHP?

When using LOAD DATA INFILE in MySQL to import data from a tab-separated file, you can specify the columns you want to import by listing them after the table name. In PHP, you can build the query dynamically by concatenating the column names based on your requirements. This allows you to import only specific columns from the file into the database. 

<?php

// Database connection
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "database";

$conn = new mysqli($servername, $username, $password, $dbname);

// Specify the columns you want to import
$columns = "column1, column2, column3";

// Path to the tab-separated file
$file = "data.txt";

// Build the query
$query = "LOAD DATA INFILE '$file' INTO TABLE table_name FIELDS TERMINATED BY '\t' LINES TERMINATED BY '\n' ($columns)";

// Execute the query
if ($conn->query($query) === TRUE) {
    echo "Data imported successfully";
} else {
    echo "Error importing data: " . $conn->error;
}

// Close the connection
$conn->close();

?>

Keywords

LOAD DATA INFILE tab-separated file specific columns import PHP

Related Questions