MySQL Forums
Forum List  »  Oracle

MYSQL QUERY HELP NEEDED
Posted by: Praveen P
Date: July 11, 2008 02:55PM

I have a query in oracle. The same query works in MySQL as well. But it is hogging memmory.

Can some one tell me what is the best alternate query for this in MySQL?

The query is

delete from web.table1 where not exists(select b.vin from web.table2 b where
web.table1.vin = b.vin) and web.table1.provider = 'XYZ';

Please advise.

Thanks in advance.

Praveen

Options: ReplyQuote


Subject
Views
Written By
Posted
MYSQL QUERY HELP NEEDED
3512
July 11, 2008 02:55PM


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.