Green World

반응형

SQLITE 쿼리 작성법 참고자료

(DB)SQLITE






http://www.sqlite.org/lang.html










반응형

반응형

span이 이미지처럼







css에 cursor:pointer; 넣으면 됨.










반응형

반응형

select 한것을 insert 하기

(DB)오라클






INSERT INTO insert_tab


select code,


  nm,


  day,


  stand


from


(with t as (


 select 'GB' code, 'AAA' nm, '18/1' day, 'ALL' stand from dual union all


 select 'GB' code, 'AAA' nm, '18/1' day, '5' stand from dual union all


 select 'GB' code, 'AAA' nm, '18/1' day, '2' stand from dual)


 select code,


   nm,


   day,


   stand


 from t)










반응형