List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:December 12 2001 3:45am
Subject:Re: Problem in using "in" keyword
View as plain text  
On Wed, Dec 12, 2001 at 11:26:05AM +0800, TH Leung wrote:
> Hi,
> I use the MySQLManager and enter a SQL statement with a "in" keyword, but an
> error message of syntax error occurs, I verify the SQL by plugging it to MS
> SQL Server 2000, it works without error, so I would like to know if the "in"
> keyword only functions on the Linux platform but not on the Windows
> platform? The MySQL version I am now using is 4.0-Max alpha and the MyODBC
> version is 2.5.

Verifying a SQL statement by sending it a different database engine than
MySQL will only tell you that it works with that engine.  It won't tell
you anything about possible differences between the Linux and Windows
versions of MySQL.

Probably you're using IN in query that uses a sub-select.  If that's
true, the answer to your question can be found in the MySQL manual:
Problem in using "in" keywordTH Leung12 Dec
  • Re: Problem in using "in" keywordPaul DuBois12 Dec
RE: Problem in using "in" keywordQuentin Bennett12 Dec