通过 JOIN 导出 MySQL 表？

发布于 2024-09-28 16:11:03 字数 264 浏览 8 评论 0原文

我想知道是否可以只导出查询结果（例如导出为 CSV），而不是创建另一个表来存储 MySQL JOIN 查询的结果？

例如，查询将是这样的..

SELECT 
    us.id,
    CONCAT_WS(' - ',cats_sic_us.sic,cats_sic_us.category) AS sic_cat
FROM
    us
    INNER JOIN cats_sic_us ON us.sic=cats_sic_us.id;

原文

I was wondering if rather than creating another table to store the results of the MySQL JOIN query is it possible to just export a queries result, like to a CSV?

The query for example would be something like this..

SELECT 
    us.id,
    CONCAT_WS(' - ',cats_sic_us.sic,cats_sic_us.category) AS sic_cat
FROM
    us
    INNER JOIN cats_sic_us ON us.sic=cats_sic_us.id;

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

总以为 2024-10-05 16:11:03

是的;

SELECT 
    us.id,
    CONCAT_WS(' - ',cats_sic_us.sic,cats_sic_us.category) AS sic_cat
INTO OUTFILE '/tmp/results.csv'
    FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
    LINES TERMINATED BY '\n'
FROM
    us
    INNER JOIN cats_sic_us ON us.sic=cats_sic_us.id;

Yup;

SELECT 
    us.id,
    CONCAT_WS(' - ',cats_sic_us.sic,cats_sic_us.category) AS sic_cat
INTO OUTFILE '/tmp/results.csv'
    FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
    LINES TERMINATED BY '\n'
FROM
    us
    INNER JOIN cats_sic_us ON us.sic=cats_sic_us.id;

回复收藏 0 原文