UPDATE tb_account_info SET passwd = CASE account WHEN '100002' THEN 'a' WHEN '100003' THEN 'b' END WHERE account IN('100002', '100003');
INSERT INTO tb_account_info(account,passwd,level)values('100002','123456','2'),('100003','123456','2');
delete from tb_account_info where account in('100002','100003');