Home > AMP

Mysql 导入导出csv

导出csv

select * from test_info
into outfile ‘/tmp/test.csv’
fields terminated by ‘,’ optionally enclosed by ‘”‘ escaped by ‘”‘
lines terminated by ‘\n’;
导入csv

load data local infile ‘/tmp/test.csv’
into table test_info
CHARACTER SET utf8
fields terminated by ‘,’ optionally enclosed by ‘”‘ escaped by ‘”‘
lines terminated by ‘\n’;

请选择你看完该文章的感受:

0不错 0超赞 0无聊 0扯淡 0不解 0路过

随机文章:

央子港一日游
央子港一日游

温控风机+遮阳棚——荆门分公司2招搞定一体化机柜降温节能
温控风机+遮阳棚——荆门分公司2招搞定一体化机柜降温节能

木工装修尾声中
木工装修尾声中

About Me
About Me

bash: fork: retry: Resource temporarily unavailable
bash: fork: retry: Resource temporarily unavailable

水又涨钱了
水又涨钱了

发表评论