Laravel SQL issues while developing

1. uploading data from csv file into mysql table

I was stuck in some issues of laravel sql issues.. please see may help you in your development.

Sql script

LOAD DATA INFILE ‘C:\Workdir\cba\actualdata.csv’

INTO TABLE user

FIELDS TERMINATED BY ‘,’

OPTIONALLY ENCLOSED BY ‘”‘

LINES TERMINATED BY ‘\n’

IGNORE 1 ROWS

(uWhatsAppNo,uEmail);

SQL query: Copy

LOAD DATA INFILE 'C:\Workdir\cba\actualdata.csv'
INTO TABLE user
FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '\n'
IGNORE 1 ROWS
(uWhatsAppNo,uEmail);