Is there a way to set limits in a sql table?

drdrake

Hi,

I want to limit the app_users table to have only 100 records. Is there a way how to do it in mysql/mariadb?

What about another solution, to send one email as soon as there are 100 records? Thanks.

PrincessOfCats

http://dev.mysql.com/doc/refman/5.7/en/trigger-syntax.html

Bochi

What about the first result of a Google search like "mysql limit table rows":

• http://stackoverflow.com/questions/8048001/how-can-i-set-a-maximum-number-of-rows-in-mysql-table