1 message in com.mysql.lists.javaI have question about MySQL jdbc.
FromSent OnAttachments
林勇02 Aug 2005 02:12 
Subject:I have question about MySQL jdbc.
From:林勇 (show@21cn.com)
Date:08/02/2005 02:12:58 AM
List:com.mysql.lists.java

jdbc mysql! I come from china.I have question about MySQL jdbc.It's example: SELECE * FROM table WHERE field IN (?) The above to SQL get zero record.But below to SQL get right record. SELECE * FROM table WHERE field IN ("value","value","value") SELECE * FROM table WHERE field = value OR field = value OR field = value

I have a suspicion that MySQL jdbc have question.

The chinese: 我来自中国。我有一个关于MySQL jdbc的问题。例如: SELECE * FROM table WHERE field IN (?) 上面这条SQL查询语句返回零条记录,但下面的SQL查询语句却能正确获得记录。 SELECE * FROM table WHERE field IN ("value","value","value") SELECE * FROM table WHERE field = value OR field = value OR field = value

我怀疑MySQL jdbc有问题。为什么用IN函数时通过参数传递却不能正确获得记录。