Hi

I have a requirement in which i have to make a table full so that no further records can be inserted into it.

I can reduce the table space also.
can someone tell me either how to reduce the tablespace or somehow fill the table completely (no manually) so that no further inserts are possible

Thanks
Abhishek

set the auto_increment of one of the rows to its maximum value

alter table <tablename> auto_increment =222300

is this correct

that should do it, except when i said "maximum" i meant the largest possible value for your auto_increment, not the largest value it currently has

If i understood correctly this is the maximum number of rows that can be inserted right?

Its is taking a lot of time
more than 30 min and still not done.

First Be clear what you have to do Reduce table space or limit max table

What engine is table using ?

I want a situation in which no new row can be inserted into the a table