SELECT d.uuid,d.drug_id,d.concept_id,d.name,d.dosage_form,d.strength, cn.name, cn.locale, d.date_created,d.date_changed
FROM drug as d
INNER JOIN concept_name as cn ON cn.concept_id=d.concept_id
WHERE YEAR(DATE(d.date_created))='2014'
INTO OUTFILE '/var/lib/mysql-files/drugs4.csv'
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\n';