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函数时通过参数传递却不能正确获得记录。