- Documentation Library
- Table of Contents
- MySQL 5.5 Manual
- MySQL 5.4 Manual
- MySQL 5.1 Manual
- MySQL 5.0 Manual
- MySQL 3.23/4.0/4.1 Manual
- Table of Contents
- A.5.5 Query-Related Issues
- A.5.5.1 Case Sensitivity in String Searches
- A.5.5.2 Problems Using DATE Columns
- A.5.5.3 Problems with NULL Values
- A.5.5.4 Problems with Column Aliases
- A.5.5.5 Rollback Failure for Nontransactional Tables
- A.5.5.6 Deleting Rows from Related Tables
- A.5.5.7 Solving Problems with No Matching Rows
- A.5.5.8 Problems with Floating-Point Values
MySQL does not support subqueries prior to version 4.1, or the
use of more than one table in the
DELETE statement prior to
version 4.0. If your version of MySQL does not support
subqueries or multiple-table
DELETE statements, you can use
the following approach to delete rows from two related tables:
If the total length of the
DELETE statement for
related_table is more than 1MB (the default
value of the
max_allowed_packet system
variable), you should split it into smaller parts and execute
multiple DELETE statements. You
probably get the fastest DELETE
by specifying only 100 to 1,000
related_column values per statement if the
related_column is indexed. If the
related_column isn't indexed, the speed is
independent of the number of arguments in the
IN clause.
User Comments
Oh lord please, "deletando", "gerenciador", and some more 20 words i saw before throwing up are a complete insult to the portuguese grammar.
This isn't portuguese, this is plain, non-portuguese, out-of-the-ghetto brasilian!!!!!!
There was once a time where what they spoke in Brazil was Portuguese. Not anymore. Change the link of this doc. section to some (any) other thing please.
Add your own comment.