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:
Answer to Question 2:
BTW - Please allow more than 2 hours between question and complaint.