分享到:
发表于 2009-02-13 09:47:10 楼主 | |
Create trigger edpshdb_eve before insert on eve For each row Begin Set @mount_of_eve = (Select count(*) from eve); If (@mount_of_eve>=70) then Delete from eve limit 1 ; End if; End; 创建这个edpshdb_eve触发器成功,但是在我运行我的软件insert数据时失败,出现如下提示:error[can't update table' eve' in stored founction/trigger because it is already used by statement which invoked this stored founction /trigger.] failed to dump event. 希望有高人知道答案。。。。。。 |
|
楼主热贴 |
针对ZOL星空(中国)您有任何使用问题和建议 您可以 联系星空(中国)管理员 、 查看帮助 或 给我提意见