> > 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/Optimisati
Jim,
>> 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?
Depends on which storage engine you are using. If you are using InnoDB
tables, there's
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
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 com
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 tinyin
