0
How to update a column using multiple conditions ?
If there are multiple conditions for any entity how can I update that? For Example: update all the student's mark and add 5 mark extra who attend classes more than 90% and have more than 60% marks.
2 Answers
+ 1
UPDATE students
SET marks = marks+5
WHERE attendance > 90
AND marks > 60
+ 1
UPDATE table_name
set column_name=value
where condition1 AND condition1 AND ....