Advertisement
Guest User

Untitled

a guest
Aug 22nd, 2017
72
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.62 KB | None | 0 0
  1. LOAD DATA LOCAL INFILE 'c:/Users/shrestha_manish/Desktop/MySQL/customer_reg_data.csv'
  2. INTO TABLE customer
  3. CHARACTER SET UTF8
  4. COLUMNS TERMINATED BY 't'
  5. LINES TERMINATED BY 'n';
  6.  
  7. LOAD DATA LOCAL INFILE 'c:/Users/shrestha_manish/Desktop/MySQL/customer_reg_data.csv'
  8. INTO TABLE customer
  9. CHARACTER SET UTF8
  10. COLUMNS TERMINATED BY 't' --Use this only if your column / fields terminate or are separated with tab if they are terminate with comma use FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' as given below,only use either one of them at a time.
  11. LINES TERMINATED BY 'n';
  12. FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement