MYSQL 触发器怎么转成 SQL 触发器？

litongshun 2012-01-30 03:08:43

MYSQL 触发器怎么转成 SQL 触发器？
CREATE TRIGGER ‘enterbasic_after_add_tr’ AFTER INSERT ON ‘enterbasic’
FOR EACH ROW
begin
insert into editrecord

(SYSNUM,TABLENAME,MAINKEY,CZRQ,CZSJ,CZLX,status1,status2,status3,status4) values

(null,'enterbasic',NEW.ENTERNO,now(),now(),'add','0','0','0','0');
怎么转成MSQL

...全文

69 2 打赏收藏转发到动态举报

写回复

用AI写文章

2 条回复

切换为时间正序

请发表友善的回复…

发表回复

叶子 2012-01-30

打赏
举报



--测试正常



create trigger enterbasic_after_add_tr

on enterbasic

for insert

as

insert into editrecord

(SYSNUM,TABLENAME,MAINKEY,CZRQ,CZSJ,CZLX,status1,status2,status3,status4) 

select 

null,'enterbasic',

[ENTERNO],getdate(),getdate(),'add','0','0','0','0'

from inserted









go

create table enterbasic([ENTERNO] varchar(20))

create table editrecord

(SYSNUM int,TABLENAME varchar(50),MAINKEY varchar(20),

CZRQ datetime,CZSJ datetime,CZLX varchar(20),

status1 varchar(6),status2 varchar(6),status3 varchar(6),status4 varchar(6)) 



insert into enterbasic select 'hhh'



select * from editrecord

/*

SYSNUM      TABLENAME                                          MAINKEY              CZRQ                    CZSJ                    CZLX                 status1 status2 status3 status4

----------- -------------------------------------------------- -------------------- ----------------------- ----------------------- -------------------- ------- ------- ------- -------

NULL        enterbasic                                         hhh                  2012-01-30 15:22:28.973 2012-01-30 15:22:28.973 add                  0       0       0       0

*/