하은양 믿음군 효실맘 호홍홍집s

INSERT INTO TB_MATCH_OPT ( MAT_ID, MEM_ID, OBJ_ID, OPT_ID, REGDATE ) VALUES ( (SELECT CONCAT('0',LPAD(CAST(SUBSTR(IFNULL(MAX(MAT_ID),'00000000'),2,7) AS UNSIGNED) + 1,7,0)) FROM TB_MATCH_OPT), 'B0000001', 'L0000002', 'O0000003', now() );아래와 같이 고치면 됨 (단, 1개의 값만 적용할 때 사용가능함)....1. 일반 INSERTINSERT INTO TB_MATCH_OPT ( MAT_ID, MEM_ID, OBJ_ID, OPT_ID, REGDATE ) SELECT (SELECT CONCAT('0',LPAD(CAST(SUBS..

Oracle :SELECT ********* FROM TB_RSV RSV, TB_LECTURE LEC, TB_ITEMS ITM, TB_INDATA IND, TB_CODE COD WHERE RSV.RSTATUS IN ('CRD','PRD','NRD','DRD','PER') AND RSV.RSV_ID = IND.RSV_ID AND RSV.OBJ_ID = LEC.LEC_ID(+) AND RSV.OBJ_ID = ITM.ITEM_ID(+) AND RSV.RSTATUS = COD.CD_CODE AND COD.CD_CAT1 = 'RSV' AND RSV.MEM_ID = 'null' ORDER BY RSV.OBJ_TYPE ASC, RSV.OBJ_ID, RSV.STIME; MySql :SELECT ********* FRO..

-- 트리거처리 : Mysql은 각각 하나에 대한 오류 코드: 1419You do not have the SUPER privilege and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable): 에러해결방법 1. SUPER 권한이 없는 USER2. log_bin_trust_function_creators 값이 OFF일때 (show global variables like 'log_bin_trust_function_creators';) > set global log_bin_trust_function_creators = on; DELIMITER $$

Oracle :sSql = "SELECT CALES.DATES,TO_CHAR(TO_DATE(CALES.DATES,'YYYYMMDD'),'D') DATE_WEEK,EXP_SEQ,SDATE,STIME,EDATE,ETIME,TITLE,NAME " + "FROM ( " + " SELECT TO_CHAR(TO_DATE('"+sFirstDate+"','YYYYMMDD') + ROWNUM - 1,'YYYYMMDD') DATES " + " FROM ALL_OBJECTS " + " WHERE ROWNUM = STR_TO_DATE('"+sFirstDate+"','%Y%m%d') AND TDATE = STR_TO_DATE('"+sFirstDate+"','%Y%m%d') AND TDATE

Oracle : SELECT 'L'||LPAD(TO_NUMBER(SUBSTR(NVL(MAX(LEC_ID),'L0000000'),2,7)) + 1,7,0) FROM TB_LECTURE MySql :SELECT 'L'||LPAD(TO_NUMBER(SUBSTR(NVL(MAX(LEC_ID),'L0000000'),2,7)) + 1,7,0) FROM TB_LECTURE

가끔 생각이 안날때... 기억을 위해 TB_BRANCH과 BIZ_NUM의 사업자명이 같은 것을 비교해서 TB_BRANCH에 값 update 하기 T.BIZ_NUM

select a.*, (select ifnull(count(rsv_id),0) cnt from TB_RSV where OBJ_TYPE = 'GRP' and OBJ_ID = 1 and RSTATUS in ('POK') and DATE_FORMAT(stime, '%Y%m%d%H') = concat('20160225',a.team_h) ) rsvcnt from ( select 1 AS num, '09:00' AS team_hour, '09' AS team_h union all select 2 AS num, '10:00' AS team_hour, '10' AS team_h union all select 3 AS num, '11:00' AS team_hour, '11' AS team_h union all sele..

DROP PROCEDURE IF EXISTS PRC_FillCALENDAR;DROP TABLE IF EXISTS TB_BIZDAY; CREATE TABLE IF NOT EXISTS `TB_BIZDAY` ( `TDATE` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `SDATE` datetime NOT NULL, `BDATE` datetime NOT NULL, `WEEK` int(20) NOT NULL, `DTYPE` varchar(2) DEFAULT NULL, `DTYPE2` varchar(2) DEFAULT NULL, `DSTR` varchar(30) DEFAULT NULL, `REGDATE` datetime DEFAULT NULL, `REG_ID` varch..

-- 예약 자동증가 값 테이블.. CREATE TABLE `TB_AUTO_INC` ( `AUTO_SEQ` BIGINT NOT NULL AUTO_INCREMENT, `NAMECHK_DI` VARCHAR(100), `NAMECHK_CI` VARCHAR(128), `REGDATE` DATETIME, `REG_ID` VARCHAR(100), `REG_IP` VARCHAR(30), PRIMARY KEY (`AUTO_SEQ`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; TB_AUTO_INC : 자동증가 값처리하고 LAST_INSERT_ID() 함수이용하여 최근 발생한 이전 자동증가값 가져오기처리...alter table TB_AUTO_INC auto_increment=1000; // 최초 ..

참고 : http://shonm.tistory.com/category/ibatis/like%20%EB%AC%B8%20%EC%82%AC%EC%9A%A9%EB%B2%95 오라클은 like '%'||#value#||'%' Mysql은 like concat('%','#value#','%') Sysbase, SQL SERVER like '%' + #value# + '%'