- Documentation Library
- Table of Contents
- MySQL 6.0 Reference Manual
- MySQL 5.1 Reference Manual
- MySQL 5.0 Reference Manual
- MySQL 3.23/4.0/4.1 Manual
- Table of Contents
MySQL 5.0 Reference Manual :: B Errors, Error Codes, and Common Problems :: B.1 Problems and Common Errors :: B.1.5 Query-Related Issues :: B.1.5.6 Deleting Rows from Related Tables
Section Navigation [Toggle]
- B.1.5 Query-Related Issues
- B.1.5.1 Case Sensitivity in String Searches
- B.1.5.2 Problems Using DATE Columns
- B.1.5.3 Problems with NULL Values
- B.1.5.4 Problems with Column Aliases
- B.1.5.5 Rollback Failure for Non-Transactional Tables
- B.1.5.6 Deleting Rows from Related Tables
- B.1.5.7 Solving Problems with No Matching Rows
- B.1.5.8 Problems with Floating-Point Comparisons
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.
© 1995-2008 MySQL AB. All rights reserved.
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.