使用 ' 创建触发器插入..选择...'陈述

发布于 2024-11-30 09:58:19 字数 482 浏览 0 评论 0原文

我正在编写一个插入后触发器，它将数据插入到 list_of_requests 表中，并从 emp_sup 表中获取数据。

create trigger trig_lor
after insert 
on employee_skillset
for each row begin
    insert into list_of_requests (APPROVER1,APPROVER2,LOGDATE) 
    select sup1,sup2,'#dateFormat(now(),"yyyy/mm/dd")#' from empsup
        where empno=NEW.employee_number
end

错误如下：您的 SQL 语法有错误；检查与您的 MySQL 服务器版本相对应的手册，了解在第 1 行的“在雇员技能集上插入后触发 trig_lor，每行开始 inse”附近使用的正确语法

我该如何进行这项工作？

原文

I am writing an after insert trigger which inserts data to list_of_requests table taking the data from emp_sup table.

create trigger trig_lor
after insert 
on employee_skillset
for each row begin
    insert into list_of_requests (APPROVER1,APPROVER2,LOGDATE) 
    select sup1,sup2,'#dateFormat(now(),"yyyy/mm/dd")#' from empsup
        where empno=NEW.employee_number
end

This is giving error as: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'trigger trig_lor after insert on employee_skillset for each row begin inse' at line 1

How do I make this work?

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

只有影子陪我不离不弃 2024-12-07 09:58:19

未测试但尝试一下。

delimiter //
drop trigger if exists trig_lor //
create trigger trig_lor
after insert 
on employee_skillset
for each row
begin
insert into list_of_requests (APPROVER1,APPROVER2,LOGDATE) 
select sup1,sup2,curdate() from empsup where empno=NEW.employee_number;
end; //
delimiter ;

Not tested but give it a try.

delimiter //
drop trigger if exists trig_lor //
create trigger trig_lor
after insert 
on employee_skillset
for each row
begin
insert into list_of_requests (APPROVER1,APPROVER2,LOGDATE) 
select sup1,sup2,curdate() from empsup where empno=NEW.employee_number;
end; //
delimiter ;

回复收藏 0 原文

~没有更多了~