Guest User

Untitled

a guest
Jan 23rd, 2019
119
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.58 KB | None | 0 0
  1. CREATE TABLE incoming (
  2. user_id VARCHAR(50) NOT NULL,
  3. url VARCHAR(255) NOT NULL,
  4. domain VARCHAR(100) NOT NULL,
  5. date_time DATETIME NOT NULL
  6. );
  7.  
  8. LOAD DATA INFILE 'C:/ProgramData/MySQL/MySQL Server
  9. 8.0/Uploads/incomes.csv'
  10. INTO TABLE incoming
  11. FIELDS TERMINATED BY ','
  12. ENCLOSED BY '"'
  13. LINES TERMINATED BY 'n'
  14. IGNORE 1 ROWS
  15. SET 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 |
Add Comment
Please, Sign In to add comment