반응형 c샵1 MYSQL 스케쥴러SCHEDULE 및 트리거TRIGGER 예제 CREATE EVENT IF NOT EXISTS paytime_testON SCHEDULEevery 1 minuteON COMPLETION NOT PRESERVEENABLECOMMENT '결재'DO update reservation set useyn = 'N'where DATE_ADD(logdate, INTERVAL 5 MINUTE) SHOW EVENTS;DROP EVENT staygs.paytime;DELIMITER $$CREATE TRIGGER payupdateBEFORE INSERT ON paymentFOR EACH ROW BEGINDECLARE idTemp VARCHAR(32);DECLARE answerTemp VARCHAR(32);SET idTemp = NEW.merchant_uid;SET a.. 2024. 5. 8. 이전 1 다음 반응형