我有一个表，我想根据UserName查询的值来删除其Email字段的值
例如：UserName=fsdf 我只想删除Email字段的：[email protected]！
UserName NickName Email
fsdf fdsf [email protected]} sdf sdf M 1 9
sdf sdf 123456789 [email protected] zxc zxc M 1 10
fdgsd gfdsfdsg 123456789 [email protected] fdsh fdshsd M 1 11
qqqq qqqq 111111111 [email protected] qq qq M 1 12
www www 123456789 [email protected] sfdsadf sdafs M 1
------解决方案--------------------
--不能为空,就写 ' '
update 表
set Email = ' '
where UserName= 'fsdf '