LOAD DATA INFILE/OUTFILE - importing data from & to csv into mysql

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