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:
Category:MySQL Server: DML Severity:S4 (Feature request)
Version: OS:Any
Assigned to: CPU Architecture:Any

[16 Sep 2003 13:51] Mauro Moura
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.


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.