I want to update multiple column with multiple condition. for.eg.
update student set name='john' where id=10
update student set name='doe' where id=5
How to update this in a single statement?
-
Check this SO: stackoverflow.com/questions/13673890/…Sohaib Farooqi– Sohaib Farooqi2016-07-29 10:08:18 +00:00Commented Jul 29, 2016 at 10:08
-
Also, why do you mind making separate statements?Koos Gadellaa– Koos Gadellaa2016-07-29 12:00:30 +00:00Commented Jul 29, 2016 at 12:00
Add a comment
|
2 Answers
Use CASE WHEN
update student
set name= CASE WHEN id = 5 THEN 'john'
WHEN id = 10 THEN 'doe'
ELSE name
END
where id in (
5, 10
)
Comments
update tablename
set coloumn_name1= CASE WHEN coloumn_name = 5 THEN 'john'
WHEN coloumn_name = 10 THEN 'doe'
ELSE name
END
where coloumn_name in (
5, 10
)
