Bug #1875 UPDATE supports table_references LEFT JOIN
Submitted: 18 Nov 2003 8:34 Modified: 26 Nov 2003 9:52
Reporter: Nick Gaugler Email Updates:
Status: Closed Impact on me:
Category:MySQL Server: Documentation Severity:S3 (Non-critical)
Version:4.0.4+ OS:Any (All)
Assigned to: Paul DuBois CPU Architecture:Any

[18 Nov 2003 8:34] Nick Gaugler
The documentation just states it supports [, tbl_name ...], which is confusing compared to the table_references that's supported by SELECT.  The documentation does not clearly state that UPDATE supports LEFT JOIN, possibly RIGHT, OUTER and/or INNER, etc.  Without the documentation stating this, users will never know that they can use this syntax.  Possibly some examples showing which ones work and which ones do not work.

How to repeat:

Suggested fix:
Add more details to the documentation
[18 Nov 2003 10:30] Dean Ellis
The examples in UPDATE Syntax and DELETE Syntax could both probably use demonstrations of this.

Thank you.
[26 Nov 2003 9:52] Paul DuBois
Thank you for your bug report. This issue has been addressed in the
documentation. The updated documentation will appear on our website
shortly, and will be included in the next release of the relevant

I've added a note to the UPDATE and DELETE sections
that multiple-table operations allow any kind of
join allowed in SELECT statements.