specify the limit of records that can be entered in the table

[rement]

Hi friends

Is it possible to specify the limit of records that can be entered in the table.

Regards
rement -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[jesussaves]

one way would be to set the auto_increment value high enough so that only the desired number of rows can be added before the auto_increment number hits the maximum for its datatype

for example, to limit a table to only 10 rows, create the table with a TINYINT auto_increment and set its value at 117 -- after you've added 10 rows, the auto_increment number will be 127 and you will get an error if you try to add another row -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --