在这里详述 db/mysql load file outfile。

Date 三 04 十二月 2013 By liugehao Category db.

{{{ LOAD DATA INFILE 'data.txt' INTO TABLE tbl_name FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\r\n' IGNORE 1 LINES;

select * from driver into outfile "a.txt" fields terminated by ',' enclosed by '"'; }}}

Comments !