converting XE getNextSequence() f...
2010.10.28 14:15 Khongchi
php코드로 되어 있는 xe의 getNextSequence()함수를 Mysql 함수로 구현 DELIMITER $$ CREATE FUNCTION `xe_mediaxe`.`getNextSequence`() RETURNS BIGINT(64) DETERMINISTIC BEGIN DECLARE SEQUENCE BIGINT(64); INSERT INTO `xe_sequence` (seq) VALUES ('0'); SELECT seq INTO SEQUENCE FROM xe_sequence ORDER BY seq DESC LIMIT 1; IF (SEQUENCE%10000 = 0) THEN DELETE FROM `xe_sequence` WHERE seq < SEQUENCE; END IF; RETURN SEQUENCE; END$$ DELIMITER ; USE blogtimes; DELIMITE...
Thoth개발자 Khongchi입니다.
