I have a table with the columns (store_id
, emp_id
, shift_id
, name
) where store_id
, emp_id
and shift_id
is a composite key.
I want to check first if the key is already present in table, then update name, otherwise insert new record.
I have a table with the columns (store_id
, emp_id
, shift_id
, name
) where store_id
, emp_id
and shift_id
is a composite key.
I want to check first if the key is already present in table, then update name, otherwise insert new record.