Mysql LOAD DATA demo

基本语法：load data  [low_priority] [local] infile 'file_name txt' [replace | ignore]into table tbl_name[fields[terminated by't'][OPTIONALLY] enclosed by ''][escaped by'\' ]][lines terminated by'n'][ignore number lines][(col_name,   )]local dafunction loadData(){    taPath=$1;        LOAD DATA LOCAL INFILE "$dataPath"  REPLACE INTO TABLE ad_data fields terminated by ',' (time,app_id,pkg_name,country,placement,ad_req_num,ad_req_filled_num,imp_num,click_num,revenue);}