a guest Aug 12th, 2017 45 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
- mysql> LOAD DATA INFILE '/tmp/CA.csv' replace INTO TABLE caleads2 FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n' (COMPANY_NAME, ADDRRESS, CITY, STATE, ZIP, COUNTY, WEBSITE, PHONENUMBER, ALT_PHONE, FULLNAME, POSITION, GENDER, NUMBEROFEMPLOYEES, ANNUAL_REVENUE, SIC_AND_SIC_DESCRIPTION);
- ERROR 29 (HY000): File '/tmp/CA.csv' not found (Errcode: 13)
RAW Paste Data