[Spreegem]

Is it possible to "lock" a MySQL Table so that no more things can be inserted into it after a certain number of things have been inserted? And if table 1 is locked, to insert stuff into table 2, that sort of a thing. Thank You In Advance

[NeverMind]

there is a lock option in mysql ..
but it's not what you want http://dev.mysql.com/doc/mysql/en/lock-tables.html
I don't think MySQL offers the feature you are asking for..
but you could do that with the help of php ..
you could count the number of rows in each table, with MySQL's function COUNT() and if it reached the limit you specify, then start in a new table ..
but why would you do that anyway? this will cause you trouble retraiving data as you are going to search in all tables!
database servers came to overcome this problem which was faced when using huge flat files .. but with databases, if you have a good structure, your table could handle millions of records!

[Spreegem]

Ohh, ok, thanks I was just worried that with thousands or more rows of data that it could take a while to find specific information, so I wanted to break it up, I guess it won't be a problem, Thank You for the help

[NeverMind]

just make sure you have indexes in your tables to speed them up