In the last episode (Jul 23), Jim McAtee said: > > 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? > > Since I received no responses, maybe someone can take a moment to > explain why this is such a stupid question.
Maybe not stupid, but definitely "please see the manual" questions. Answers to Question 1: http://www.mysql.com/doc/en/DELETE.html http://www.mysql.com/doc/en/Optimisation.html http://www.mysql.com/doc/en/OPTIMIZE_TABLE.html Answer to Question 2: http://www.mysql.com/doc/en/ALTER_TABLE.html BTW - Please allow more than 2 hours between question and complaint. -- Dan Nelson [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
