migration script csv loadinfile

LOAD DATA LOCAL INFILE '/home/linux/Desktop/student10.csv' INTO TABLE student_applicant_information IGNORE 1 LINES
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\n'
(ppd_lastname,
ppd_firstname,
ppd_middlename,
ppd_nickname,
ppd_gender,
ppd_bday,
ppd_age,
ppd_caddress1,
ppd_caddress2,
ppd_caddress3,
ppd_caddress5,
ppd_czipcode,
ppd_paddress1,
ppd_paddress2,
ppd_paddress3,
ppd_paddress5,
ppd_pzipcode,
ppd_citizens,
ppd_mobileno2,
ppd_email
);



mysql --local-infile -uroot -pr00tb33r dps_registrar_db < migrate.sql