mysql导出，导入csv文件 多出空记录

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 常用操作

相关热门文章

• python 多进程之管道实例（模...
• 解决mysql“Access denied for...
• MySQL数据插入、修改、删除...
• mysql启动的四种方式
• 【原创】PostgreSQL 实现MySQL...

• linux dhcp peizhi roc
• 关于Unix文件的软链接
• 求教这个命令什么意思，我是新...
• sed -e "/grep/d" 是什么意思...
• 谁能够帮我解决LINUX 2.6 10...

给主人留下些什么吧！~~

评论热议