IN clause

have some problems  with mysql. can't find the exact phrase from the MySQL Documentation about this. Anyway, one of the guy from asp.net forum ask some unusual question. I encounter this before and I don't want this to be a burden soon.

In this, I use world.sql (sample db) from MySQL sample db's.

tried to execute this SQL statement  (we need to test something. just made up something like this one):

SELECT Name FROM city GROUP BY Name HAVING MAX(`Population`) > 10000 LIMIT 20;

after that, we need to execute something like

DELETE FROM city WHERE Name IN(SELECT Name FROM city GROUP BY Name HAVING MAX(`Population`) > 10000 LIMIT 20);

Well, we can see a helpful message. 🙂
This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery'

thought of something to have the same.. and my last bet is to have a single line. like:

DELETE FROM city WHERE Name IN('name1', 'name2', 'name3');

if anyone would like to share some of their ideas, you might like to refer me a site. you can use my contact page above.

Cheers,

Leave a Reply