好吧，根据您给的小提琴，我尝试了这些，对我有用
create table account( account_id number primary key, account_status varchar2(30));insert into account values(1, '5');insert into account values(2, '3');insert into account values(3, '2');select * from accountupdate accountset account_status= casewhen account_id=1 then '2'when account_id=2 then '5'when account_id=3 then '3'ENDselect * from account
我没有使用where条件
