Maximum number of entries

[Saltire]

Hi there,

I need to be able to set the mysql db I have set up to allow a maximum number of entries of up to 17 rows - how can I do this?

[r937]

create table mytable
( id tinyint not null primary key auto_increment
, foo varchar(9)
) auto_increment=111

[Saltire]

Is that 111 what I enter to make sure it can only accept 17 rows or is that a generic auto increment number?

Also, I was just requested that it be changed to 10 rows and not 17.

[r937]

the technique (it's actually more of a hack) relies on the fact that you cannot have a tinyint number greater than 127

if you want only 10 rows, declare your table with 118 as the auto_increment