MySQL 5.4 Reference Manual :: B Errors, Error Codes, and Common Problems :: B.5 Problems and Common Errors :: B.5.5 Query-Related Issues :: B.5.5.6 Deleting Rows from Related Tables
Section Navigation [Toggle]
- B.5.5 Query-Related Issues
- B.5.5.1 Case Sensitivity in String Searches
- B.5.5.2 Problems Using DATE Columns
- B.5.5.3 Problems with NULL Values
- B.5.5.4 Problems with Column Aliases
- B.5.5.5 Rollback Failure for Nontransactional Tables
- B.5.5.6 Deleting Rows from Related Tables
- B.5.5.7 Solving Problems with No Matching Rows
- B.5.5.8 Problems with Floating-Point Values
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.