468,243 Members | 1,974 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,243 developers. It's quick & easy.

illegal query

Hello,

I'm kind of new to mySQL but more used to Sybase/PHP
What is illegal about this query or can i not use combined query's in mySQL?

DELETE FROM manufacturers
WHERE manufacturers_id NOT IN ( SELECT manufacturers_id
FROM
products )

Kind Regards
Joost Wolthuis

Jul 16 '05 #1
1 3226
In comp.lang.php joost wrote:
I'm kind of new to mySQL but more used to Sybase/PHP
What is illegal about this query or can i not use combined query's in mySQL?

DELETE FROM manufacturers
WHERE manufacturers_id NOT IN ( SELECT manufacturers_id
FROM
products )


Many versions of MySQL don't support subselects. I think some of the
newest bleeding-edge versions do, but 3.x (which is probably what you're
running, as 4.0 is still fairly young) doesn't, period, IIRC.

....dave
Jul 16 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Frances Del Rio | last post: by
5 posts views Thread by Dave | last post: by
10 posts views Thread by webmaster | last post: by
8 posts views Thread by Just another C hacker | last post: by
1 post views Thread by JRough | last post: by
reply views Thread by kermitthefrogpy | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.