sql 更新字段

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

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

原文地址:https://www.cnblogs.com/hellowzd/p/4188150.html