How To Import CSV Into MySQL? - Scaler Topics

LOAD DATA INFILE 'C:/ProgramData/MySQL/MySQL Server 8.0/Uploads/Employee_Details.csv' 
INTO TABLE  Employee_Details
FIELDS TERMINATED BY ','  
OPTIONALLY ENCLOSED BY '"'  
LINES TERMINATED BY '\r\n'   
IGNORE 1 ROWS  
SET Date= STR_TO_DATE(@Date, '%m/%d/%Y');