Limit the size of a MySQL table

[jme]

Hi Guys,

Is there a way (either through SQL or PHP) to limit the size of a table. So, for example, I can make sure that a table can't contain more than 100 sets of data?

Also, if it is possible, when the table is 'full' what error will be returned?

[MarkR]

No, you can't limit the number of rows in a table in MySQL. There is an option max_rows, but that does not limit the number of rows to that, it simply ensures that the table structure can hold at least that many rows (often, it enables it to contain far more).

You should handle this at the application layer.

Ok, technically you could place a trigger on there, but don't do that, it smells.

Mark

[Sxooter]

What, exactly, are you trying to do?

build a queue?

short term storage where you only need the latest 100 rows?

Generally, if you want a queue, you can just have the app delete as many rows off one end that it adds to another.

More info on what you're trying to do might lead to a clearer answer from us.