考试
1970-01-01 08:00:00

下面选项中,更新account表中money字段值,其取值在

题目描述

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

答案解析

update account set money = money + 50 where money <=200 and money >=100; --- update account set money = money + 50 where money between 100 and 200;

加载中...
AI正在思考中,请稍候...