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