$sql='SELECT id FROM mytable WHERE x=?'id ='.$id.' and is '(is_null($id)?'null':'not null'));
但是,当测试时,PHP $stmt->fetchColumn()返回的内容似乎是空的。MySQL在shell中测试时表示MySQL returned an empty result set
我的目的是:从一个值列表中获取多个行,比如(1,2,3,4,5),('a','b','c',‘and’)等等。mysql> select id from accounts where id in (1,2,3,4,5,6);| id || 1 || 3 || 6 |5 rows in set (0.00 sec)
上面的sql当然是可以<em