LOAD DATA INFILE/OUTFILE on Mysql
SELECT * INTO OUTFILE '/tmp/result.csv'FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'LINES TERMINATED BY '\n' FROM Timesjob;
LOAD DATA INFILE "/TimesJob/11.csv/aa.csv" INTO TABLE Timesjob FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n';
No comments:
Post a Comment