SQLize Online / PHPize Online  /  SQLtest Online

create table test_w (cnt int, empl varchar(50), id int); ------------------------------------------------------ insert into test_w values (20, 'Слесарь', 2); insert into test_w values (30, 'Монтажник', 2); insert into test_w values (20, 'Монтажник', 3); insert into test_w values (50, 'Уборщик', 3); insert into test_w values (20, 'Директор', 1); ------------------------------------------------------ update test_w set empl = case when id = 1 then 'One' when id = 2 then 'Two' when id = 3 then 'Three' end and set cnt = case when id = 1 then '100' when id = 2 then '200' when id = 3 then '300' and where id in (1, 2, 3); ----------------------------------------------------- select * from test_w