56,677
社区成员
发帖
与我相关
我的任务
分享
delimiter //
CREATE TRIGGER tbl1_ai AFTER INSERT ON tbl1
FOR EACH ROW BEGIN
delete from tbl1 where (select count(*) from tbl1 where SingInDateTime >= NEW.SingInDateTime) >5;
END;
delimiter;
insert into tbl1 values
(null,now(),'Report','1');