I want to create a table that should have max 5 rows. So if I add a new row and the table already have 5 rows, the trigger should delete the first row and add the new row.
e.g.:
my_table
id | data
---------
1 | a
---------
2 | b
---------
3 | c
---------
4 | d
change to
my_table
id | data
---------
2 | b
---------
3 | c
---------
4 | d
---------
5 | e