Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- LOAD DATA LOCAL INFILE 'c:/Users/shrestha_manish/Desktop/MySQL/customer_reg_data.csv'
- INTO TABLE customer
- CHARACTER SET UTF8
- COLUMNS TERMINATED BY 't'
- LINES TERMINATED BY 'n';
- LOAD DATA LOCAL INFILE 'c:/Users/shrestha_manish/Desktop/MySQL/customer_reg_data.csv'
- INTO TABLE customer
- CHARACTER SET UTF8
- 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.
- LINES TERMINATED BY 'n';
- FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement