Monday 28 September 2015

Different varieties in Using LOAD DATA Command

LOAD DATA LOCAL INFILE '/$FilePath/$FileName'
                    REPLACE
                    INTO TABLE $TableName
                    FIELDS TERMINATED BY '|' OPTIONALLY ENCLOSED BY '\"'
                    LINES TERMINATED BY '\n'
                    IGNORE 1 LINES
*********************************************************************************

LOAD DATA LOCAL INFILE '/vol2/HCC_DATA/COVENTRY/201507/HCC_Report_Existing_Lost_201507_460-74-9142.csv'
                                    REPLACE
                                    INTO TABLE imports_payer_data.cov_member_hccs_raw_table
                                    FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '\"' 
                                    LINES TERMINATED BY '\r\n'
                                    IGNORE 1 LINES (msotin,msonam,membno,lname,fname,dob,gender,eff_date,category,sort_order,hcc1,hcc2,hcc3,hcc4,hcc5,hcc6,hcc7,hcc8,hcc9,hcc10,hcc11,hcc12,hcc13,hcc14,hcc15, hcc16, hcc17, hcc18, hcc19, hcc20, hcc21, planid, medprac, provno, pcp_name, gpaparent, adrln1, adrln2, citycd, stacod, zipcod, pcp_county, current_period_begin, current_period_end, datestamp, hic, @received_date)  SET received_date = now()
***********************************************************************************