How to output data to csv?

Question

linux

Good afternoon, there is a script that displays 2 columns, how can I display this whole creation by cells into a csv file

SET NAMES WIN1251;
select table_name from table;
select dp.code, DP.INSTANCE_CODE, count(*)
from DX DP
where DP.STAT = 2
group by 1,2
order by count(*) desc;
OUTPUT TO '/opt/sometable.csv' FORMAT ASCII DELIMITED BY ',' QUOTE ''

What did I do wrong? Run in Linux

Answer 1

Armor-piercing:

select 
    row = field_1 +","+field_2+","+field_3