load data infile '/test.csv' into table table_name fields terminated by ',' optionally enclosed by '"' escaped by '"' lines terminated by '/r/n' ignore 1 lines;
导csv：
复制代码 代码如下:
SELECT * INTO OUTFILE '/test.csv' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '/n' FROM table_name;
