一 语法
UPDATE table_name
SET column1=value1,...
[WHERE conditions]
二 实例
1、无条件更新
sql> update userinfo2set userpwd='111111';已更新4行。sql>select userpwd from userinfo;--------------------111111111111111111111111sql> update userinfo2set userpwd='111',email='cakin@qq.com';sql>select userpwd,email from userinfo;
@H_404_87@USERPWD EMAIL--------------------------------------------------111 cakin@qq.com111 cakin@qq.com111 cakin@qq.com111 cakin@qq.com
USERPWD
2、有条件更新
