Insert data from CSV in one column and custom input in other columns with LOAD DATA INFILE in MySQL?

Question

I have a pre-defined table (with data) in a MySQL database with 3 columns:

brandId INT AUTO_INCREMENT,
brand CHAR,
insertDateTime DATETIME

And I have a list of brands stored in a csv file (10,000 rows).

I want to insert the brands into the table as new rows, with insertDateTime shows the date time of the insertion.

I know I can use LOAD DATA INFILE to load the brands from the csv, and I can use the NOW() function to compute insert datetime as we go, but how to combine them in one query?

GMB · Accepted Answer · 2020-04-15 22:57:34Z

1

You can use the SET clause of LOAD DATA to provide values that do not come from the input file.

Consider the following syntax:

LOAD DATA INFILE 'myfile.csv'
INTO TABLE mytable (brand)
SET insertDateTime = NOW();

answered Apr 15, 2020 at 22:57

GMB

224k25 gold badges103 silver badges151 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Insert data from CSV in one column and custom input in other columns with LOAD DATA INFILE in MySQL?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related