MySQL delete first row when new is added when at 15 rows

Question

When there are 15 rows in a table and then i add a new row, is there a way to automatically delete the first row in that table?

so it should be like this: ids 1-15 , then when i add a new one: ids 2-16 ,then again i add a new one: ids 3-17 and so on.

edit1: i now have this code but it doesn't work for me.

    $this->db->select('count(*)');
    $this->db->from('chat');

    $countChat = $this->db->get();

    if ($countChat >= '16') {
        $this->db->delete();
        $this->db->from('chat');
        $this->db->order_by('id');
        $this->db->limit('1');
    }

Answer 1

If you only want to keep 15 rows in the table in total, then:

delete
from yourtable
where yourid < (select yourid
                from yourtable
                order by yourid desc
                limit 14, 1)