![](https://lstatic.shangxueba.com/jiandati/pc/images/pc_jdt_tittleico.png)
数据表user表含有如下字段 id(int11 AUTO_INCREMENT),username(varchar20),password(varchar50),logins(int11) 在user表中有一条记录,账号为“zhangsan”,密码为“123456”,登录次数为“0”,修改张三的密码为“654321”的语句是
A、insert into user(username,password,logins) values(‘zhangsan’,’654321’,0);
B、update user set password=654321 where username=’zhangsan’;
C、update user set password=’654321’ where username=’zhangsan’;
D、update user password=’654321’ where username=’zhangsan’;
![](https://lstatic.shangxueba.com/jiandati/pc/images/jdt_panel_vip.png)
![](https://lstatic.shangxueba.com/jiandati/pc/images/no_answer.png)