Skip to content

Instantly share code, notes, and snippets.

@snickerjp

snickerjp/CSVandIF.sql

Created March 8, 2012 09:40
Show Gist options
  • Save snickerjp/1999976 to your computer and use it in GitHub Desktop.
Save snickerjp/1999976 to your computer and use it in GitHub Desktop.
Download ZIP
CSV出力とIF関数
Raw
CSVandIF.sql
select
IF(FLAG=1,'OK','NG')
from
DATA
where
ID = 001
INTO OUTFILE "/tmp/test.csv" FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment