Top "Load-data-infile" questions

A mySQL function for loading external data directly into the database.

MySQL Load Data Infile auto incremented ID value

I want to insert an ID column to my table and get data of this table from a text file. …

mysql indexing auto-increment load-data-infile
infile .csv file in sas with header

I have a csv file which named dataset1.csv and it contains header with 3 variables att1 (character), att2 and att3 (…

sas load-data-infile
mysql "datetime NOT NULL DEFAULT '1970-01-01' " gets turned to 0000-00-00 00:00:00

I have a column created as `date_start` datetime NOT NULL DEFAULT '1970-01-01' However when I upload …

sql mysql load-data-infile default-constraint
MySQL: Loading multiple files into a table

I've been trying to load multiple files into a table, so that they would fit the same row. I can …

mysql sql load-data-infile
mysql load data infile where clause

I need to update existing rows in table with load data infile based on some condition, is this possible? load …

mysql load-data-infile
Finding MySQL errors from LOAD DATA INFILE

I am running a LOAD DATA INFILE command in MySQL and one of the files is showing errors at the …

sql mysql load-data-infile
LOAD DATA INFILE error 1064

I am running this MySQL command: LOAD DATA LOCAL INFILE 'books.csv' INTO TABLE BOOK (Book_id, @dummy, Title, Publisher_…

mysql load-data-infile
mysql load data local infile syntax issues with set fields

I'm trying to use mysql's LOAD DATA LOCAL INFILE syntax to load a .csv file into an existing table. Here …

mysql csv load-data-infile truncated
Importing bulk CSV data in UTF-8 into MySQL

I'm trying to import about 10K rows of UTF-8 encoded data into a new MySQL table. I can do so …

mysql utf-8 csv load-data-infile
LOAD DATA LOCAL INFILE fails - from php, to mysql (on Amazon rds)

We're moving our database from being on the webserver to a separate server (from an Amazon EC2 webserver to an …

php mysql amazon-rds load-data-infile