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);

MySQL said: #29 - File 'C:\xampp\mysql\data\Workdircbaactualdata.csv' not found (Errcode: 2 "No such file or directory")

Solution: put the script inside as directed in error message: