SHARE
TWEET

Untitled

a guest Jun 24th, 2019 48 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. 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
  2. FROM drug as d
  3. INNER JOIN concept_name as cn ON cn.concept_id=d.concept_id
  4. WHERE YEAR(DATE(d.date_created))='2014'
  5. INTO OUTFILE '/var/lib/mysql-files/drugs4.csv'
  6. FIELDS TERMINATED BY ','
  7. ENCLOSED BY '"'
  8. LINES TERMINATED BY '\n';
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!
 
Top