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;
