Bug #1309 EXCEPT statement
Submitted: 16 Sep 2003 13:51 Modified: 26 Nov 2005 11:59
Reporter: Mauro Moura Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: DML Severity:S4 (Feature request)
Version: OS:Any
Assigned to: CPU Architecture:Any
Triage: Triaged: D5 (Feature request)

[16 Sep 2003 13:51] Mauro Moura
Description:
The EXCEPT statement would very useful, since it plays an important role in relational algebra, corresponding to DIFERENCE which is one of the five elementar operations.

    Thanks,
        Mauro

How to repeat:
It's not a bug, so you can't repeat it.
[26 Nov 2005 11:59] Valeriy Kravchuk
Thank you for a feature request. 

SQL 2003 Standard prescribes to support UNION, EXCEPT and INTERSECT relational operators in SELECT statements. I belive that one day MySQL will support them all, not only UNION [ALL].
[3 Jan 2008 15:38] Susanne Ebrecht
Bug #33200 is a duplicate of this bug here.