select T1.col1,T1.col2,T2.col1,T2.col2 from table1 T1,table2 T2 where T1.id =T2.id INTO OUTFILE ‘test.csv’ FIELDS TERMINATED BY ‘,’ ENCLOSED BY ‘”‘ LINES TERMINATED BY ‘\n’;
select T1.col1,T1.col2,T2.col1,T2.col2 from table1 T1,table2 T2 where T1.id =T2.id INTO OUTFILE ‘test.csv’ FIELDS TERMINATED BY ‘,’ ENCLOSED BY ‘”‘ LINES TERMINATED BY ‘\n’;