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
