Top "Load-data-infile" questions

Using LOAD DATA INFILE to upload csv into mysql table

I'm using LOAD DATA INFILE to upload a .csv into a table. This is the table I have created in …

mysql load-data-infile

MySQL fields terminated by tab

I am trying to upload a tab delimitted file with MySQL. I want a query something likes this: LOAD DATA …

mysql load-data-infile

MYSQL: Display Skipped records after LOAD DATA INFILE?

In MySQL I've used LOAD DATA LOCAL INFILE which works fine. At the end I get a message like: Records: 460377 …

sql mysql load-data-infile

LOAD DATA from CSV file where doublequote was used as the escape character

I have a bunch of CSV data that I need to load into a MySQL database. Well, CSV-ish, perhaps. (edit: …

mysql sql csv load-data-infile rfc4180

mysql infile convert string to time format

I have a TSV that I'm trying to infile into a mySQL table. A couple columns are time formats, but …

mysql sql time load-data-infile

Trying to do LOAD DATA INFILE with REPLACE and AUTO_INCREMENT

I am trying to load a file onto a MySQL database, having the primary key auto_incremented and I would …

mysql replace auto-increment load-data-infile

MySQL Convert latin1 data to UTF8

I imported some data using LOAD DATA INFILE into a MySQL Database. The table itself and the columns are using …

sql mysql collation load-data-infile

mysql LOAD DATA INFILE with auto-increment primary key

I am trying to load a data file into mysql table using "LOAD DATA LOCAL INFILE 'filename' INTO TABLE 'tablename'". …

python mysql import load-data-infile

How to use LOAD DATA INFILE statement when file is another location?

I want to use LOAD DATA INFILE statement to import data in my table. If the file is available on …

mysql load-data-infile

LOAD DATA LOCAL INFILE gives the error The used command is not allowed with this MySQL version

I have a PHP script that calls MySQL's LOAD DATA INFILE to load data from CSV files. However, on production …

mysql csv load-data-infile csv-import