想写个触发器，当数据库某个表的行数达到一定的行数时自动删除这个表的记录,该怎么解决

create trigger tt
on tb
for insert
begin
if (select count(*) from tb)>100000
delete tb where id<1000
end

------解决方案--------------------
--删除全部啊

SQL code

create trigger tt
on tb
for insert
begin
if (select count(*) from tb)>100000
truncate table tb
end

------解决方案--------------------

SQL code

create trigger tt
on tb
for insert
begin
while(@@rowcount>=10)
truncate table tb
end