yz3Hyf9Q

1CREATE TABLE incoming (
2user_id  VARCHAR(50) NOT NULL,
3url  VARCHAR(255) NOT NULL,
4domain VARCHAR(100) NOT NULL,
5date_time DATETIME NOT NULL
6);
7
8LOAD DATA INFILE 'C:/ProgramData/MySQL/MySQL Server
98.0/Uploads/incomes.csv'
10INTO TABLE incoming  
11FIELDS TERMINATED BY ',' 
12ENCLOSED BY '"'
13LINES TERMINATED BY 'n' 
14IGNORE 1 ROWS
15SET  date_time = FROM_UNIXTIME(date_time
16);
17
18 example of first 4 rows of csv file (including headers)
19
20  | user_id |   domain   |    time    |
21  |    1    | @gmail.com | 1546366951 |
22  |    2    | @gmail.com | 1546354528 |
23  |    3    | @gmail.com | 1546365429 |