MySQL - Multiple set on LOAD DATA INFILE
csv, load, mysql
Solution
I do not understand if columns `inserted_date` and `inserted_by` already exists in your table. If no than you can add them before runing `LOAD DATA INFILE`:
LOAD DATA INFILE 'name.csv' INTO TABLE table1
FIELDS TERMINATED BY ','
LINES TERMINATED BY '\n'
IGNORE 1 LINES
(@no, @name)
set
no = @no,
name = @name,
inserted_date = now(),
inserted_by = 'me'
Problem
I've a `table_name` like this: ``` No | Name | Inserted_Date | Inserted_By ===================================== ``` and then I've file name.csv like this ``` no,name 1,jhon 2,alex 3,steve ``` I want to load these file `table_name` using syntax like this: ``` LOAD DATA INFILE 'name.csv' INTO TABLE table1 FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n' IGNORE 1 LINES ??? ``` the question is, what should I put on `???` so I can store data like this: ``` No | Name | Inserted_Date | Inserted_By ===================================== 1 | jhon | sysdate() | me 2 | ales | sysdate() | me 3 | steve | sysdate() | me ```