Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE incoming (
- user_id VARCHAR(50) NOT NULL,
- url VARCHAR(255) NOT NULL,
- domain VARCHAR(100) NOT NULL,
- date_time DATETIME NOT NULL
- );
- LOAD DATA INFILE 'C:/ProgramData/MySQL/MySQL Server
- 8.0/Uploads/incomes.csv'
- INTO TABLE incoming
- FIELDS TERMINATED BY ','
- ENCLOSED BY '"'
- LINES TERMINATED BY 'n'
- IGNORE 1 ROWS
- SET date_time = FROM_UNIXTIME(date_time
- );
- example of first 4 rows of csv file (including headers)
- | user_id | domain | time |
- | 1 | @gmail.com | 1546366951 |
- | 2 | @gmail.com | 1546354528 |
- | 3 | @gmail.com | 1546365429 |
Add Comment
Please, Sign In to add comment