问题详情

下面选项中，更新account表中money字段值，其取值在100-200之间，现在将money字段值增加50，能够正确执行上述要求的SQL语句是

A．update account set money + 50 where money >=100 and money <=200;

B．update account set money = money + 50 where money >=100 or money <=200;

C．update account set money = money + 50 where money between 100 and 200;

D．update account set money = money + 50 where money <=200 and money >=100;