Re: Trigger to limit number of rows in another table

[Peter Brawley]

You'd need Insert & Update Triggers on Table 1, each saying something like ...

declare n smallint;
set n = ( select count(*) from table2 ) - NEW.MaxNumberOfRowsTable2;
if n > 0 then
delete from table2 order by id limit n;
end if;