How can you exclude certain columns while importing data using LOAD DATA INFILE in PHP?

When using LOAD DATA INFILE in PHP to import data into a database, you can exclude certain columns by specifying the columns you want to import in the query. This can be achieved by listing only the columns you want to import in the query and skipping the columns you want to exclude. 

// Connect to the database
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "database";
$conn = new mysqli($servername, $username, $password, $dbname);

// Import data excluding certain columns
$query = "LOAD DATA INFILE 'data.csv' INTO TABLE table_name (column1, column2, column4)";
$result = $conn->query($query);

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

Keywords

LOAD DATA INFILE PHP exclude columns import data data manipulation

Related Questions