mysql - 是否可以创建在任何表中的任何插入时触发的触发器？

Question

我想创建一个 MySQL 触发器，它在任何表中的任何行插入之前运行。那可能吗？另一种方法是在为每个表插入之前创建一个触发器，但这还不够好:它很混​​乱并且不处理新表，所以我肯定想编写一个 MySQL 触发器，它在任何插入到任何排。那可能吗？如果是这样，如何？ (我在文档中找不到任何引用)

Answer 1

寻找代替触发器例如:在 sql server 中

create trigger name
on table_name
instead of insert 
as
begin
if exists9select count(*) from inserted as i
join table_name as t
on i.id-t.id
group by i.id
having count(*) >1)
begin
raiseerror "duplicate category names npt allowsed"
end
else
insert into table_name (col1,col2)
select col1,col2 from inserted

`create trigger name
on table_name
instead of insert 
as
begin
if exists9select count(*) from inserted as i
join table_name as t
on i.id-t.id
group by i.id
having count(*) >1)
begin
raise error "duplicate category names not allowed"
end
else
insert into table_name (col1,col2)
select col1,col2 from inserted
end
go

`