MySQL Forums
Forum List  »  Oracle

Re: HOW TO CONVERT ORACLE TO MYSQL
Posted by: Roland Bouman
Date: March 09, 2006 02:09PM

like in all rdbms-es:

select ...
from ...
where col1 not in (
select somecol1
from sometable
)
and (col2,col3) not in (
select somecol2,somecol3
from sometable
)
and col4 not in ('a','b','c')


see:
http://dev.mysql.com/doc/refman/5.1/en/comparison-operators.html
and
http://dev.mysql.com/doc/refman/5.1/en/any-in-some-subqueries.html



Edited 1 time(s). Last edit at 03/09/2006 02:09PM by Roland Bouman.

Options: ReplyQuote


Subject
Views
Written By
Posted
43720
January 03, 2005 10:56PM
25585
February 10, 2005 05:20PM
12581
August 26, 2005 03:28AM
11226
March 09, 2006 06:57AM
Re: HOW TO CONVERT ORACLE TO MYSQL
10538
March 09, 2006 02:09PM
7797
June 20, 2006 06:42PM
6246
January 23, 2006 10:37AM
5154
January 23, 2006 02:26PM
4616
September 30, 2006 01:18AM
5102
February 06, 2007 12:17AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.