Export a MySQL table via JOIN?

Question

Hey guys..... 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;

Thanks a lot!

Answer 1

you can maybe use

 select into outfile

Answer 2

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;