首页 > itarticle > mysql 导入导出csv 导入

mysql 导入导出csv 导入

admin 11月 11, 2020 0

SELECT * FROM mytable 
INTO OUTFILE '/tmp/mytable.csv'
FIELDS TERMINATED BY ',' 
OPTIONALLY ENCLOSED BY '"' 
LINES TERMINATED BY 'n'；

导入

LOAD DATA INFILE '/tmp/mytable.csv' 
INTO TABLE mytable 
FIELDS TERMINATED BY ',' 
OPTIONALLY ENCLOSED BY '"' 
LINES TERMINATED BY 'n';