How to create...

[Ilan Fait]

Hi,

 1) I am migration from Oracle to MySQL DB. How can I create the SEQUENCE
and the TRIGGER in MySQL "style"/"way"
.
/**********************************************/
CREATE SEQUENCE SYS_MSG_TEMPL_SEQ MINVALUE 1 MAXVALUE 999999999999999 CYCLE;

CREATE TRIGGER sys_msg_templ_trig 
BEFORE INSERT ON SYS_MSG_TEMPL 
REFERENCING OLD AS OLD NEW AS NEW 
FOR EACH ROW 
BEGIN
    SELECT sys_msg_templ_seq.NEXTVAL INTO :new.template_id FROM dual;
End;
/
/**********************************************/

 CREATE SEQUENCE AD_MNG_SYS_SEQ MINVALUE 1 MAXVALUE 999999 CYCLE; 
 
 CREATE TRIGGER AD_MNG_SYS_TRIG 
 BEFORE INSERT ON AD_MNG_SYS 
 REFERENCING OLD AS OLD NEW AS NEW FOR EACH ROW 
 BEGIN 
 Select AD_MNG_SYS_SEQ.NEXTVAL INTO :new.AMS_ID FROM Dual; 
 END; 
 
/**********************************************/

2) what is equal to 'sysdate' (to get/put the system date in a 
     table) in MySQL DB. 

  Thanks,
  Ilan

_________________________________________
ILAN FAIT
Tel: 972-9-9519133  Ex.247    iWeb Technologies
Fax: 972-9-9519134                91 Medinat Ha'Yehudim St.
                                                     Herzliya 46120 IL
mailto:[EMAIL PROTECTED]    www.iweb.com