$sql="UPDATE a SET status='0' WHERE
(
SELECT b.id,b.expressions,
a.id
FROM b,a
WHERE b.id=".$id." AND b.expressions=0 AND b.id=a.id
) AND name=$login_name";
哪里错了?
(
SELECT b.id,b.expressions,
a.id
FROM b,a
WHERE b.id=".$id." AND b.expressions=0 AND b.id=a.id
) AND name=$login_name";
哪里错了?
UPDATE a SET status='0' where a.id in
(
SELECT b.id,b.expressions,
a.id
FROM b,a
WHERE b.id=".$id." AND b.expressions=0 AND b.id=a.id) AND name=$login_name
错误提示
(
SELECT b.id,b.expressions,
a.id
FROM b,a
WHERE b.id=".$id." AND b.expressions=0 AND b.id=a.id)
这里面的select 结果有b.id b.expressions a.id三个字段呐。这里的select 里应该只能一个字段吧LZ要把条件说清楚。符合什么条件才更新?
SELECT b.id FROM b,a WHERE b.id=".$id." AND b.expressions=0 AND b.id=a.id )