오늘 날린 쿼리

대상리스트쿼리

SELECT ID  EMS_M_ID,
      NAME EMS_M_NAME,
      EMAIL EMS_M_EMAIL,
      EMAIL_FLAG SHOW_YN
 FROM CO_TABLE
 WHERE EMAIL_FLAG ='N'


단순기본매핑

SELECT CONTENTS FROM THANKS_TABLE


List Mapping

SELECT PHONE AS MAP1, QUANTITY AS MAP2, CASH AS MAP3, ID AS EMS_M_ID, EMAIL_FLAG AS SHOW_YN
FROM THING_LIST_TABLE
WHERE
ID = '@{EMS_M_ID}'


업데이트쿼리

UPDATE
 CO_TABLE
SET
 EMAIL_FLAG ='Y'
WHERE
 ID='@{EMS_M_ID}'

학교뎅겼을때 공부 겁나 안해서 이런;;