Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- LOAD DATA INFILE '/path/file' INTO TABLE cdr_records (@dummy,
- @dummy,
- @dummy,
- @dummy,
- dateTimeOrigination,
- @dummy,
- @dummy,
- @dummy,
- callingPartyNumber,
- @dummy,
- @dummy,
- @dummy,
- @dummy,
- @dummy,
- @dummy,
- @dummy,
- @dummy,
- @dummy,
- @dummy,
- @dummy,
- @dummy,
- @dummy,
- @dummy,
- @dummy,
- @dummy,
- @dummy,
- @dummy,
- @dummy,
- @dummy,
- originalCalledPartyNumber,
- finalCalledPartyNumber,
- @dummy,
- @dummy,
- @dummy,
- @dummy,
- @dummy,
- @dummy,
- @dummy,
- @dummy,
- @dummy,
- @dummy,
- @dummy,
- @dummy,
- @dummy,
- @dummy,
- @dummy,
- @dummy,
- @dummy,
- @dummy,
- @dummy,
- pkid,
- @dummy,
- @dummy,
- @dummy,
- @dummy,
- duration,
- @dummy,
- @dummy,
- @dummy,
- @dummy,
- @dummy,
- @dummy,
- @dummy,
- @dummy,
- @dummy,
- @dummy,
- @dummy,
- @dummy,
- @dummy,
- @dummy,
- @dummy,
- @dummy,
- @dummy,
- @dummy,
- @dummy,
- @dummy,
- @dummy,
- @dummy,
- @dummy,
- @dummy,
- @dummy,
- @dummy,
- @dummy,
- @dummy,
- @dummy,
- @dummy,
- @dummy,
- @dummy,
- @dummy,
- @dummy,
- @dummy,
- @dummy,
- @dummy,
- @dummy,
- @dummy,
- @dummy,
- @dummy,
- @dummy,
- @dummy,
- @dummy,
- @dummy,
- @dummy,
- @dummy,
- @dummy) FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY 'n' IGNORE 2 LINES;
- ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY 'n' IGNORE 2 LIN' at line 104
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement