You can also discard an input value by
assigning it to a user variable and
not assigning the variable to a table
column:
LOAD DATA INFILE 'file.txt'
INTO TABLE t1 (column1, @dummy, column2, @dummy, column3);
More Related Contents:
- How do I import CSV file into a MySQL table?
- Import data in MySQL from a CSV file using LOAD DATA INFILE
- MySQL load NULL values from CSV data
- How to import a CSV file into a MySQL table
- Importing a csv into mysql via command line
- Import CSV to MySQL
- LOAD DATA LOCAL INFILE gives the error The used command is not allowed with this MySQL version
- SQL split values to multiple rows
- How can I output MySQL query results in CSV format?
- What is the opposite of GROUP_CONCAT in MySQL?
- MySQL LOAD DATA INFILE with ON DUPLICATE KEY UPDATE
- MySQL: Split comma separated list into multiple rows
- Mysql string split [duplicate]
- Dump all tables in CSV format using ‘mysqldump’
- Importing a CSV to MySQL with different date format
- mysql pivot query results with GROUP BY
- How to export data from SQL Server 2005 to MySQL [closed]
- Dump a mysql database to a plaintext (CSV) backup from the command line
- access denied for load data infile in MySQL
- PHP – Import CSV file to mysql database Using LOAD DATA INFILE
- How can I correct MySQL Load Error
- Mysql permission errors with ‘load data’
- How to insert selected columns from a CSV file to a MySQL database using LOAD DATA INFILE
- MySQL load data infile – acceleration?
- How to join two tables using a comma-separated-list in the join field
- Import CSV to Update only one column in table
- How I can Import data from CSV to MySQL?
- Import CSV to Update rows in table
- How to import a csv file into MySQL workbench?
- Escaping the colon character ‘:’ in JPA queries