mysql trigger触发器有关问题

分类: IT文章 • 2023-03-21 18:42:49

mysql trigger触发器问题
CREATE TRIGGER SetUserHome after insert ON users
FOR EACH ROW
BEGIN
insert into test ...
END

在执行完insert users 后如何执行：查询users表获取所需结果插入或更新进test中

------解决方案--------------------
CREATE TRIGGER SetUserHome after insert ON users
FOR EACH ROW
BEGIN
insert into test  select * from users where id=new.id;
END