Hello,
I have a table with the following data.
Example: Original Entry.
+--------+-------+-------------+
| ProjID | UsrID | Role |
+--------+-------+-------------+
| 5 | 2 | incharge |
| 5 | 5 | member |
| 5 | 6 | member |
| 5 | 1 | member |
+--------+-------+-------------+
and this table could be updated with this data
modified entry
+--------+-------+-------------+
| ProjID | UsrID | Role |
+--------+-------+-------------+
| 5 | 3 | member |
| 5 | 5 | incharge |
| 5 | 6 | member |
| 5 | 1 | member |
+--------+-------+-------------+
or with this data
modified entry
+--------+-------+-------------+
| ProjID | UsrID | Role |
+--------+-------+-------------+
| 5 | 3 | member |
| 5 | 7 | incharge |
| 5 | 1 | member |
+--------+-------+-------------+
and any combination. Persons(UsrID) involved on a particular project (ProjID = 5) could increase or decrease and anybody could be a member or could be the incharge. Example: a form submitted with the following data (this is the new data to be updated in the database)
submit #1: for ProjID = 5
UsrID Role
2 incharge
4 member
submit #2: for ProjID = 5
UsrID Role
2 incharge
4 member
6 member
submit #3: for ProjID = 5
UsrID Role
4 member
3 member
7 incharge
8 member
Now my question is this. What would be the proper way of updating this table? I'm thinking of this steps.
DELETE the old record from the database first.
delete from table_name where ProjID='5'
then INSERT those new submitted (submit #1,2 or 3) data.
any recommendation is apreciated.
thanks!!
