create or replace
TRIGGER ATTENCE_1
after INSERT ON HrmScheduleSign
for each row
BEGIN
INSERT INTO uf_2019_ATTENCE (uesrid,username,subcompanyid,subcompanyname,departmentid,departmentname,attendance_date,attendance_time)
select b.id,b.lastname,c.id,c.subcompanyname,d.id,d.departmentname,a.signdate,SUBSTR(signtime,1,5) from HrmScheduleSign a left join Hrmresource b on a.userid=b.id
left join hrmsubcompany c on c.id = b.subcompanyid1
left join hrmdepartment d on d.id = b.departmentid
LEFT JOIN uf_rykqxxsz e ON a.userid =e.bh where a.isincom='1' and e.dklx is not null;
END;
不知道要怎么修改，這樣寫法是插入整個表的資料 而不是新增的資料，我想要的是當HrmScheduleSign有新資料插入時候，自動插入到uf_2019_ATTENCE 連同后面查詢出來的結果一起插入。 insert select 是不是不能在觸發器里使用？
uj5u.com熱心網友回復：
:new.欄位名 呼叫新的轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/46462.html
標籤：開發
上一篇：蘋果虛擬機的安裝