sql 更新字段

UPDATE Ypeople
SET power='0'
WHERE power='1';

 

 UPDATE Ypeople SET power='1' WHERE power='0' and pid='22'