Export z tabeli do pliku CSV

SELECT "Nazwa Firmy", "Płeć", "Imię", "Nazwisko", "Stanowisko", "Tel", "Email", "Komórka"

UNION

SELECT
  c.name,
  CASE cc.is_man WHEN 2 THEN "K" WHEN 1 THEN 'M' ELSE '-' END,
  cc.firstname, cc.lastname,
  IFNULL(cc.stanowisko, "-"), IFNULL(cc.tel, "-"), IFNULL(cc.email,"-"), IFNULL(cc.kom,"-")
FROM company_contacts cc
 INNER JOIN companies c ON c.id = cc.company_id
ORDER BY cc.company_id, cc.lastname, cc.firstname
LIMIT 20

INTO  OUTFILE '/tmp/company_contacts.csv'
      CHARACTER SET CP1250
      FIELDS ENCLOSED BY ""
      TERMINATED BY ';'
      ESCAPED BY '\\'
      LINES TERMINATED BY '\n'
;