Limiting Rows in MySQL?
I'm looking to find a way to let users use a MySQL database, but I want to limit the size of their database, and assigning a disk quota to the database file seems like an inherently bad idea. The best way I could think of would be to somehow limit the number of rows a user is allowed to have. (It would be into a fixed database; they could not add their own columns or anything.)
Anyway, is there a way to limit the number of rows that can be inserted into a MySQL database? I've spent some time searching, but everything just applies to using something like "LIMIT 0, 30" to limit the rows *retrieved*.
Is this somehow possible?
