Oracle 문법 MySQL 로 변경시 참조

1. TO_CHAR(reg_date,'YYYYMMDD')  => date_format(reg_date, '%Y-%m-%d')
2. TO_CHAR(sysdate,'YYYYMMDD')   => date_format(now(), '%Y-%m-%d')
3. sysdate       => now()
4. NVL            => innull
5. decode(tra_mthd,2,1,0)                   => if(tra_mthd=2,1,0)

​

6. TO_CHAR(TO_DATE(start_date, 'YYYY-MM-DD'), 'YYYY-MM-DD')   
     => str_to_date(date_format(start_date, '%Y-%m-%d'), '%Y-%m-%d');

// 2중 쿼리문에 rownum 사용시

7. rownum  RNUM    => @rownum:=@rownum+1 as RNUM

                              => 서브 쿼리 select 문 필드명에 아래 내용 추가(콤마 주의!)

                                   , (select @rownum:=0) as rownum 추가

8. LIKE '%' || #search_word# || '%'    => LIKE concat('%', #search_word#, '%')