RE: Problem in using in keyword

2001-12-11 Thread Quentin Bennett 

Hi,

It would help if you can post the statement and the error message that you
get.

Regards

Quentin

-Original Message-
From: TH Leung [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, 12 December 2001 4:26 p.m.
To: '[EMAIL PROTECTED]'
Subject: Problem in using in keyword


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.

Moreover, currently I come across another problem of using MySQL on Windows
platform. The MySQL database contains several tables which have Chinese
(BIG5) characters as data value, and I have constructed some programs in
PowerBuilder to  capture these Chinese data. The programs seem function
normally and the data is really captured into the tables. However, when I
try to use the mysqlcheck or myisamchk on these tables, a message saying
that the XXX.MYD needs to be recreate is appeared. I think the indexes of
these tables are corrupted. So, do you have any experiences that can share
with me in capturing Chinese data?

Thank you very much for your help.

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

The information contained in this email is privileged and confidential
and intended for the addressee only. If you are not the intended 
recipient, you are asked to respect that confidentiality and not 
disclose, copy or make use of its contents. If received in error 
you are asked to destroy this email and contact the sender immediately. 
Your assistance is appreciated.

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Problem in using in keyword

2001-12-11 Thread Paul DuBois 

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:

http://www.mysql.com/doc/A/N/ANSI_diff_Sub-selects.html

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php