var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Reducing table space
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
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