On Mon, Jan 29, 2001 at 01:30:57PM +0100, Tim Samshuijzen wrote:
>
>
> Hello,
>
> I have just deleted thousands of records but the file
> is still the same size as before. How do I make the
> file compact? i.e. how do I get rid of all the "empty
> spaces" in the table?
Look at the MySQL manual. Reference >> DELETE explicitly mentions
OPTIMIZE TABLE for such cases.
G'luck,
Peter
--
I am the thought you are now thinking.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
