mysql to csv

Zawsze zapominam:

select m.kierunkowy,p.prefix,vn.callerid,vn.typ 
INTO OUTFILE '/tmp/numery.csv' 
FIELDS TERMINATED BY ';' 
LINES TERMINATED BY '\n' 
from s3_oss.voip_numery vn 
join s3_oss.prefix p on (p.prefix=vn.prefix) 
join s3_teren.miasta m on (m.id_miasta=p.id_miasta) 
where p.id_miasta=9 and p.aktywny=1 and p.typ_prefixu='normalne' and p.id_typu_numeru=1 
order by vn.callerid;