I need help on my update statement,
the condition is , i have to update the status .
the table name is leave_request , it contain leave_req_id, date_applied,emp_id,leave_type_id,leave_period_id,leave_status
and the default for leave_status is 'Pending'
the problem is, choose approve, and on the database should change the leave_status into 'Approve' ,
It change, but it change the whole row, how can i write the update statement so it can only affect 1 row?