List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:January 16 2000 2:02pm
Subject:Re: SQL: looking for "IN (SELECT blabla FROM blablaTable)" in
MySQL
View as plain text  
At 4:55 PM -0800 2000-01-15, Raffael Heinzer wrote:
>Grüezi,
>   I'd like to delete some records in the common SQL way in MySQL:
>"DELETE FROM [table] WHERE [i] IN (SELECT [u] FROM [anotherTable] WHERE
>...)"
>
>I figured out that "IN (12, 13, 14)" with a list of constants works -
>but I need to have there something dynamically... :(
>
>Is there any way of doing that in a different way in MySQL (or is my
>statement incorrect?) or do I have to put that logic into the DBClient?


You must put the logic in your client.

-- 
Paul DuBois, paul@stripped
Thread
SQL: looking for "IN (SELECT blabla FROM blablaTable)" in MySQLRaffael Heinzer16 Jan
  • Re: SQL: looking for "IN (SELECT blabla FROM blablaTable)" in MySQLSasha Pachev16 Jan
    • Re: SQL: looking for "IN (SELECT blabla FROM blablaTable)" in MySQLTim Bunce17 Jan
      • Re: SQL: looking for "IN (SELECT blabla FROM blablaTable)" in MySQLMichael Widenius17 Jan
        • Re: SQL: looking for "IN (SELECT blabla FROM blablaTable)" in MySQLTim Bunce17 Jan
  • Re: SQL: looking for "IN (SELECT blabla FROM blablaTable)" inMySQLPaul DuBois16 Jan