当前位置:   article > 正文

mysql导出,导入csv文件 多出空记录_fields terminated by ',' optionally enclosed by

fields terminated by ',' optionally enclosed by

1,导出表table_a的数据为CSV文件a.csv

windows下的情况:

select * from table_a  

into outfile '/tmp/a.csv'   

fields terminated by ',' optionally enclosed by '"' escaped by '"'   

lines terminated by '\r\n';      

linux下将lines terminated by '\r\n'; 改为lines terminated by '\n';

否则会多出两条空记录

2,将a.csv导入至表table_a

load data infile '/tmp/a.csv'

into table table_a  

fields terminated by ','  optionally enclosed by '"' escaped by '"'

lines terminated by '\r\n';

同理:

linux下将lines terminated by '\r\n'; 改为lines terminated by '\n';

<script>window._bd_share_config={"common":{"bdSnsKey":{},"bdText":"","bdMini":"2","bdMiniList":false,"bdPic":"","bdStyle":"0","bdSize":"16"},"share":{}};with(document)0[(getElementsByTagName('head')[0]||body).appendChild(createElement('script')).src='http://bdimg.share.baidu.com/static/api/js/share.js?v=89860593.js?cdnversion='+~(-new Date()/36e5)];</script>
阅读(522) | 评论(0) | 转发(0) |
0

上一篇:IE6 fixed 兼容问题

下一篇:vi 常用操作

给主人留下些什么吧!~~
评论热议
本文内容由网友自发贡献,转载请注明出处:https://www.wpsshop.cn/w/代码探险家/article/detail/807939
推荐阅读
相关标签
  

闽ICP备14008679号