Since I received no responses, maybe someone can take a moment to explain why
this is such a stupid question.


----- Original Message ----- 
From: "Jim McAtee" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, July 23, 2003 1:28 PM
Subject: Is it necessary to compress tables?


> Does MySQL automatically handle deleted row cleanup, or is it necessary to
> periodically do this manually for tables with a lot of deletions?  If it's
> manual, what are the SQL commands to do this?
>
> Also, what happens when changes are made to a field definition?  From, say,
int
> to smallint, or tinyint to int, or varchar(255) to varchar(10)?  Do temporary
> tables get created and the data copied over, or does unused space end up in
the
> data files, to be collected later?


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to