美文网首页
MySql csv文件导入导出

MySql csv文件导入导出

作者: Liuzz25 | 来源:发表于2019-03-21 14:16 被阅读0次

导入
load data infile '/www/user_reports.csv' into table records fields terminated by ',' optionally enclosed by '"' escaped by '"' lines terminated by '\r\n';
导出
select * from records into outfile '/www/tmp/user_reports.csv' fields terminated by ',' optionally enclosed by '"' escaped by '"' lines terminated by '\r\n';

相关文章

网友评论

      本文标题:MySql csv文件导入导出

      本文链接:https://www.haomeiwen.com/subject/nrhxyqtx.html