I have a table with 2 columns: sample_id and sample_period.
sample_id: it is an ID of samples stored in another table.
sample_period: it is an ID of chronologies which I stored in another table.
I could not make sample_id unique or primary as they can be duplicated (a sample can have more chronologies).
Example:
| sample_id | sample_period |
|---|---|
| 377 | 2 |
| 377 | 3 |
I am using DataGrip to deal with my tables (MariaDB), but I cannot delete or update some rows. It is a large database for my PhD project, so recreating the table would be almost impossible at this point. Do you have any advice?
Whenever I try to delete or update a row I get the error: Unexpected update count received (Actual: 3, Expected: 1)
Thank you in advance!
