Load data from file to mysql

load-data.sql

LOAD DATA LOCAL INFILE '/home/echo/Desktop/CCBD007.txt' INTO TABLE accounts_temp FIELDS TERMINATED BY '|' LINES TERMINATED BY '\n' IGNORE 1 LINES (cust_no , acctno , cycle , @lsstdt , bk1 , abc , @open , crelim , hibal , @purdt , @pymdt , dqamcr , dqamx , dqam30 , dqam60 , dqam90 , dqam120 , dqam150 , dqam180 , dqam210 , dqamto , hist24 , @pydudt , amlspy , stcode , @dtstch , sex , @dob , @stdt , newbl , cycdu , bi , tot_currbal , cardno , bkc , @blockdtc, basu , @expdtc , chargeoff , name1 , name2 , haddr1 , haddr2 , haddr3 , city , hposc , hphone1 , hphone2 , mobile_phone_1 , employer_1 , offaddr1 , offaddr2 , offaddr3 , offcity, offposc , offphone1 , offphone2 , ecname , ecadr1 , ecadr2 , echph , ecoph , agnttag , pcode , logo , due ) SET lsstdt = str_to_date( @lsstdt , '%d/%c/%Y'), open = str_to_date( @open , '%d/%c/%Y'), purdt = str_to_date( @purdt , '%d/%c/%Y'), pymdt = str_to_date( @pymdt , '%d/%c/%Y'), pydudt = str_to_date( @pydudt , '%d/%c/%Y'), dtstch = str_to_date( @dtstch , '%d/%c/%Y'), dob = str_to_date( @dob , '%d/%c/%Y'), stdt = str_to_date( @stdt , '%d/%c/%Y'), blockdtc = str_to_date( @blockdtc , '%d/%c/%Y'), expdtc = str_to_date( @expdtc , '%d/%c/%Y');