mysql导出csv性能_mysql导出csv

1.正常查询

SELECT a.emp_no '员工号',b.seq '文章序号' from vote_records a INNER JOIN vote_content b ON a.vote_content_id = b.id

| 90150967 | 19 |

| 90150967 | 5 |

| 90150967 | 6 |

| 90150967 | 7 |

| 90150967 | 8 |

| 90150967 | 20 |

| 90150967 | 15 |

| 90150967 | 12 |

2.导出csv查询

SELECT a.emp_no '员工号',b.seq '文章序号' from vote_records a INNER JOIN vote_content b ON a.vote_content_id = b.id into outfile '/home/mysql/2020123103.csv';

两列数据合并到一列了

3.导出csv以空格分开

SELECT a.emp_no '员工号',b.seq '文章序号' from vote_records a INNER JOIN vote_content b ON a.vote_content_id = b.id into outfile '/home/mysql/2020123103.csv' fields terminated by ' ';

4.导出csv以列分隔

SELECT a.emp_no '员工号',b.seq '文章序号' from vote_records a INNER JOIN vote_content b ON a.vote_content_id = b.id into outfile '/home/mysql/2020123104.csv' fields terminated by ',';