in
$sql="SELECT * FROM product_detail WHERE did IN(SELECT proId FROM xm_star) ";
product_detail查询要求是,在xm_star中查询到proId(可以是多个)
where id in (1,2,3)
就是查询id=1 or id=2 or id=3的意思
in
$sql="SELECT * FROM product_detail WHERE did IN(SELECT proId FROM xm_star) ";
product_detail查询要求是,在xm_star中查询到proId(可以是多个)
where id in (1,2,3)
就是查询id=1 or id=2 or id=3的意思