Max Rows

[Mandrutza]

Does anyone know how to state a maximum number of rows in a table? I tried to create the table with MAX_ROWS=5 but didn't work. I hope that tomorow I'll still be alive and kicking.

 

[sleipnir214]

I don't think there is such a thing in MySQL.

What database system are you coming from, where you expect this functionality to exist? ______________________________________________________________________

http://www.tuxedo.org/~esr/faqs/smart-questions.html

TANSTAAFL!

 

[Mandrutza]

Then what's the use of MAX_ROWS ?
Anyway, i'm giving acces to a certain customer to a certain table and I want to limitate the numer of rows he can insert in that table. Is it possible in MySQL? I hope that tomorow I'll still be alive and kicking.

 

[sleipnir214]

MAX_ROWS doesn't set the absolute limit to the number of rows you can store in a table. It is a clue to MySQL when creating a table as to how much to allocate to internal pointers.

According to this page of the MySQL online documentation:

http://www.mysql.com/doc/en/Table_size.html

If you need bigger tables than 4G (and your operating system supports this), you should set the AVG_ROW_LENGTH and MAX_ROWS parameter when you create your table ______________________________________________________________________

http://www.tuxedo.org/~esr/faqs/smart-questions.html

TANSTAAFL!